Exporting contacts to excel

  • Thread starter Thread starter Gerd
  • Start date Start date
G

Gerd

Using Outlook 2003 on a Vista Business system i want to export some of my
contracts to Excel 2003.

The export works great but when going into Excel each cell with a value has
a ' in front of the value. I would have to delete that special character
from each of the cells.

How can I do the export without the '?
 
Gerd said:
Using Outlook 2003 on a Vista Business system i want to export some of my
contracts to Excel 2003.

The export works great but when going into Excel each cell with a value
has a ' in front of the value. I would have to delete that special
character from each of the cells.
Click to expand...


In Excel just do a "Find" and Replace with nothing.
 
I already tried that. I had copied the special character and pasted into the
find search field. However when doing a replace or replace all I get a
message that nothing has been found.

I don't see the that character on the spreadsheet but when clicking on a
cell with a value I see it in the formular bar. If I click next to that flag
in the formular bar the flag also becomes visable in the cell. And removing
the flag shifts the cell value to the left.

Any other ideas?
 
The behaviour your are seeing is not related to Outlook but rather is a
function of the Excel driver used to create the file (ergo - doesn't matter
what program creates an Excel file using the Microsoft Excel driver - the
same thing occurs).

Quickest/simplest solution - save your output to a CSV file and then open
that in Excel.

Karl
___________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com
 
Thanks Karl, that did the trick. I had already tried space delimited but
that did not import into Excel well.
 
Back
Top