G Guest Apr 29, 2004 #1 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?
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 Apr 29, 2004 #2 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
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
