remove a hard return in a cell

S

slickrok

how do I remove a hard return from a cell?
A find and replace mechanism for it would be great!
 
S

Sean Timmons

you can type =clean(cell name) to remove the formatting. Course, this would
also remove all spaces...
 
B

Bernard Liengme

Select cell(s)
Edit | Find/replace
In Replace What enter Alt+0010
In With What - leave blank
best wishes
 
D

David Biddulph

If by a hard return you mean Alt-Enter, then Edit/ Replace/ Find what:
Control J/ Replace with: [nothing]
 

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

Replacing a phrase with carriage returns 1
Removing a repeated words 0
Newbie Help - IF Yes No Function 0
Proposal template with removable sections 0
MS Word normal.dot cannot be fixed 'text box' appears each time 4
Highlighted 6
How can the font and size of (all) citation numbers be altered? 1
Word macro that can call cells out of Excel for a find and replace 0

Top