How to remove a line break within a cell

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?
 
G

Gord Dibben

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
 

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
line break does not appear in CSV 3
Line break 1
Breaking a line within a formula - HELPHELP PLEASE 2
Starting a new line 2
Every cell has a page break?!?! 8
Word Removing unwanted "lines" within a MS Word 10 table 1
Remove Manual Line Breaks in Cell 3

Top