Line wrapping pitfall in excel
From raju
line wrapping pitfall in excel
Watch out for the way excel wraps long lines in the function bar. When there are two words separated by space and the second word is very long, excel shows it as
smallword
jlfsdjsdjldsjldsjlfjdljlsjksdfjkldsfjkldfsjlkdfajlkjsdfdasjdlkfdsj
instead of something like
smallword jlfsdjsdjldsjldsjlfjdljlsjksdfjkldsfjkldfsjlkdfaj
lkjsdfdasjdlkfdsj
To see the entire field, expand the function bar by dragging it down.
Screenshot of the problem:
Schreenshot of the solution: