How to remove a line break within a cell

D

Debbie

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
 
Top