How to remove a line break within a cell

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

Guest

I am attempting to remove line breaks from within a cell to make a continuous text string. I would like to be able to select an entire colume and remove all the line breaks from within each cell. Any help?
 
Debbie

Try Edit>Replace

what: ALT + 0010(on numpad)
with: space(or nothing)

OR ALT + 0013

If this fails, try the CLEAN Function.

Gord Dibben Excel MVP
 
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

how do I remove line breaks from several cells? 6
Breaking a line within a formula - HELPHELP PLEASE 2
Word Removing unwanted "lines" within a MS Word 10 table 1
Alt + Ent No Longer Creates Line Break Within Cell 2
Every cell has a page break?!?! 8
Line break 1
Removing unwanted "lines" within a MS Word 10 table 2
how to remove the page break lines in a spread sheet, 1

Back
Top