find Line feeds

  • Thread starter Thread starter Rhys
  • Start date Start date
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.
 
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.
 
Back
Top