find Line feeds

R

Rhys

I'm trying to clean up a spreadsheet that seems to have
linefeeds in some cells. How do I search for these line
feeds?

thanks,

rhys.
 
D

David McRitchie

Hi Rhys,
There are two characters that may be involved, Excel itself
only pays attention to line-feed which can be entered as Alt+Enter
and supplies you with a gratuitous cell wrapping under format, cells.
Since Excel (on PCs) does not use the carriage-return you will see
the square box character (square bullet) for carriage-return and
several other unprintable characters.
 
Top