Importing From Excel, need to separate City,State,Zip from 1 column to 3 fields

[Burger108]

Hey,

I have 1500 contacts in an Excel 2007 spreadsheet. One column has the City, State, and Zip combined. When I import into Act! 2009, it shoves it all into the Address1 field. So, there is nothing in the State and Zip fields of Act and when I print labels, it looks fine except Act puts a comma after the zipcode.

Is there any way I can force Act into separating the data? Thanks for your thoughts on this matter.

Regards,

Andrew

[Burger108]

Correction, it shoves the City, State, and Zip into the City field of Act.

Andrew

[Roy_Laude…]

No, you need to do the separation in Excel before you do the import.

[Burger108]

Thanks,

Andrew

[TerryB99]

If you are uisng Excel 2007 it is easy.

Go To Data

Select Text To Columns

If you have a space or comma between each entry in the cell select Delimited and choose either comma or space and drag to select how many columns you want and