exporting categories - excel

[Annemarie en Jeroen]

Exporting categories from msoutlook contacts to excel



In our company we still use msword97, excel97 and outlook with this version
(it is true!).

All our companycontacts (1000) are in outlook/contacts and we use many
company related categories in contacts. When I export the contacts to excel,
the categories are placed in one cell, separated by a column (or semi
colon??). When I try to mail merge from the category column in excel in
word, I cannot make extractions from the category column. Is there anybody
who can tell me how to solve this problem?

The problem again in short: I cannot make a mailmerge only for certain
categories from outlook contacts (the 97-version). By the way; I also have
problems doing this in later versions. I am very glad if anybody can help me
out.

Maybe a more simple question; how do you separate text that is in one cell
of excel and transfer it to different cells?



Thanks in advance!



Jeroen

(working for Dutch government)

 

[jeff]

Hi,

I'm not sure this will help, but in Excel 2002 you can
go to Data-->>Text to columns.. and complete info.
With this you can, ie, separate names:

Before Cell A1: John G. Jones
After Cell B1: John
C1: G.
D1: Jones
and so on... Perhaps this will help with your categories?

jeff

 

[Dave Peterson]

If your data is separated by semicolons (all one column), select that column and
do:

Data|text to columns
choose delimited
Choose semicolon

And tell excel what each field should be (text/general/date/etc).

In the USA version, when I rename the .CSV (comma separated values) to .txt, I
can get that same wizard to show up when I do File|open.

I'm not sure what the extension for .CSV is in Dutch.