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


instead of something like

smallword jlfsdjsdjldsjldsjlfjdljlsjksdfjkldsfjkldfsjlkdfaj

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