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:

Excel line wrap pitfall screenshot1.JPG

Schreenshot of the solution:

Excel line wrap pitfall screenshot2.JPG