How do I remove line breaks in Excel cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Line breaks in Excel 2
line break does not appear in CSV 3
Line breaks in my cells... 3
how do I remove line breaks from several cells? 6
I want to copy cell from word that includes line breaks to excel 1
Every cell has a page break?!?! 8
Alt-Enter Line Breaks 2
Removing Manual Line Breaks in Multiple Cells 2

Back
Top