Is there a way to remove carriage return in Excel exported frm Out

R

RachelC

I am trying to remove carriage returns in Excel. The information I needed
was exported from Outlook. Please Help!
 
J

Jason Morin

Select the data, press Ctrl+H, hold down the Alt key, and
type 0010 from your numeric keypad. Leave "Replace With"
empty. Replace all.

HTH
Jason
Atlanta, GA
 
G

Gord Dibben

Rachel

If you have carriage returns in a cell you should be able to see them if you
turn off "text wrapping" on that cell.

You will see a square box at each return.

Try Edit>Replace

what: ALT + 0010(on numpad)
with: space(or nothing)

OR ALT + 0013

If this fails, try the CLEAN Function.

Post back if more is needed. There are a few other avenues of approach.

Gord Dibben Excel MVP
 
Top