importing from Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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!
Click to expand...


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