sorting of a column/sheet

  • Thread starter Thread starter john
  • Start date Start date
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.
 
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
 
John

Go back to Outlook and Export as CSV for Windows.

Open this file in Excel.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 4
keeping subtotals accurate to reflect sorting... 1
Problems Importing Excel to Outlook 1
Summarizing category 1
Need to average division of two columns based on criteria 4
SUMIFS function help 6
averaging a cell 1
Sort order not being matched in pivot table 2

Back
Top