How do I remove line breaks in Excel cells?

H

Holly

I have a series of cells in Excel with line breaks embedded within them.
When I go to save the worksheet as a .txt file, this corrupts the data.
Search and replace does not detect them.
 
D

Dave Peterson

If you used alt-enters, you should be able to use edit|replace to get rid of
them:

Edit|replace
what: alt-0010 (hit and hold the alt key and type 0010 on the numeric keypad)
with: (spacebar) (or whatever you want)

Replace all.

It may not look like xl is putting anything in, but try it anyway.
 
Top