importing from Excel

P

PaulH7436

I am trying to import from Excel and into Outlook 2003. The column for Zip
Codes is created by concatenating three other columns (including the dash).
Not all my rows have the zip+4 data. All my contacts were imported but only
the ones with a basic five digit zip code show the zip in Outlook. I tried
changing the column to TEXT, but no luck. Any suggestions are appreciated.
THANKS!
 
G

Gordon

PaulH7436 said:
I am trying to import from Excel and into Outlook 2003. The column for Zip
Codes is created by concatenating three other columns (including the
dash).
Not all my rows have the zip+4 data. All my contacts were imported but
only
the ones with a basic five digit zip code show the zip in Outlook. I
tried
changing the column to TEXT, but no luck. Any suggestions are
appreciated.
THANKS!


Do the concatenation in a column outside the import range. Then when that's
all done, do a Copy-Paste Special-Values from the column with the
concatenation results in into the column within the import range.
 

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

Top