Replacing <CR> <LF> in a cell

  • Thread starter Thread starter SueOlson
  • Start date Start date
S

SueOlson

A return address was stored in a single cell for each record in my Excel
2000 spreadsheet. The spreadsheet needs to be saved as a .prn text
file and subsequently loaded by control file into an Oracle database
(no tabs allowed).

The address has three lines (name, street address and city, state, zip)
with <CR><LF> after each line. What I need to do is remove each of the
<CR><LF> from each cell and replace it with a space. The cell
currently looks like this:

Any Name
123 Any Street
Anytown, USA 00001

It needs to look like this:
Any Name 123 Any Street Anytown, USA 00001

Can anyone tell me how to accomplish this?

Thanks!
 
One possible way,

edit>replace> in the replace what box hold down the alt key while typing 010 on the numpad (you won't see anything)
in the replace with box press space, click replace all (You might want to try 013 as well)
 
Back
Top