Exporting contacts to excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gerd - 02 Nov 2007 15:08 GMT

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 '?

Reply to this Message

Gordon - 02 Nov 2007 15:31 GMT

> 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.

In Excel just do a "Find" and Replace with nothing.

Reply to this Message

Gerd - 02 Nov 2007 16:03 GMT

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?

>> Using Outlook 2003 on a Vista Business system i want to export some of my
>> contracts to Excel 2003.
[quoted text clipped - 4 lines]
>
> In Excel just do a "Find" and Replace with nothing.

Reply to this Message

Karl Timmermans - 02 Nov 2007 23:59 GMT

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

> Using Outlook 2003 on a Vista Business system i want to export some of my
> contracts to Excel 2003.
[quoted text clipped - 4 lines]
>
> How can I do the export without the '?

Reply to this Message

Gerd - 03 Nov 2007 18:28 GMT

Thanks Karl, that did the trick. I had already tried space delimited but
that did not import into Excel well.

> 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
[quoted text clipped - 19 lines]
>>
>> How can I do the export without the '?

Reply to this Message