sorting of a column/sheet

J

john

I exported from Outlook 2000 to an excel format, my
contact list of customers. With Outlook you can have
your contacts in more than one category such as Business
and Contractors. When exporting from Outlook, it doesn't
seperate the two categories. Once in excel, is there an
easy way to seperate the two categories that ended up in
one column? The whole sheet has a column for name
Title,address, category, email address, etc.
 
J

JulieD

Hi John

you might like to look at the data / text to columns option for separating
the data ...

please post back if you need more help (with a sample of the "combined
column" typed out - not attached).

Cheers
JulieD
 
G

Gord Dibben

John

Go back to Outlook and Export as CSV for Windows.

Open this file in Excel.

Gord Dibben Excel MVP
 
Top