Find Carriage Returns

  • Thread starter Thread starter Bruce
  • Start date Start date
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
 
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 **
 
Back
Top