Find Carriage Returns

B

Bruce

I would like to search a portion of a spreadsheet and
replace the carriage returns with spaces. I am trying to
use the find/replace command. However, I can't figure out
what to place in the "Find What" field.

Thanks for any assistance,
-b
 
P

Paul B

Bruce, I think what you want is to type Alt+010 in the find box, hold the
Alt
key and type 010 on the numeric keypad. and in the replace with box put a
space

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
 
Top