how do I remove a hard return from a cell? A find and replace mechanism for it would be great!
S slickrok Aug 8, 2007 #1 how do I remove a hard return from a cell? A find and replace mechanism for it would be great!
S Sean Timmons Aug 8, 2007 #2 you can type =clean(cell name) to remove the formatting. Course, this would also remove all spaces...
you can type =clean(cell name) to remove the formatting. Course, this would also remove all spaces...
B Bernard Liengme Aug 8, 2007 #3 Select cell(s) Edit | Find/replace In Replace What enter Alt+0010 In With What - leave blank best wishes
Select cell(s) Edit | Find/replace In Replace What enter Alt+0010 In With What - leave blank best wishes
D David Biddulph Aug 8, 2007 #4 If by a hard return you mean Alt-Enter, then Edit/ Replace/ Find what: Control J/ Replace with: [nothing]
If by a hard return you mean Alt-Enter, then Edit/ Replace/ Find what: Control J/ Replace with: [nothing]
