Import

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a csv file, of contacts, that was exported from
Outlook. When you bring this into excel, the street field
may have multiple information,
ex.-123 Main Street
PO Box 999
What happens with this is, it puts a return between the
two entries. It also does this to the note field. It puts
a square whre the return is. I want to break this into two
columns in excel. What I would like to know, is there any
way to do a mass replace for this return with, say a ^
(carrot). That way I can break this into seperate columns
using the carrot. Any help would be greatly appreciated.
Thanks.

John
 
John

If possible save the *.csv file as *.txt file then use the Text Import Wizard.

If not, select your *.csv imported data in Excel and Data>Text to Columns.
Make sure you have a couple of empty columns to the right of this column.
Excel will overwrite without asking.

First screen check "de-limited">Next in "other" box enter ALT + 0010(using
numpad keys). You won't see anything in box but hit Next. Excel should have
split your data into separate columns. Hit "Finish".

Other CR codes are 0013 and 0160 if 0010 won't work.

Gord Dibben XL2002
 
Back
Top