Reply
New Member
Burger108
Posts: 5
Country: United States
Message 1 of 5 (1,378 Views)

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

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

Please use plain text.
New Member
Burger108
Posts: 5
Country: United States
Message 2 of 5 (1,376 Views)

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

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

 

Andrew

Please use plain text.
Platinum Elite Contributor
Roy_Laudenslage
Posts: 5,426
Country: United States
Message 3 of 5 (1,376 Views)

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

No, you need to do the separation in Excel before you do the import.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Tech Benders
royel@techbenders.com
Please use plain text.
New Member
Burger108
Posts: 5
Country: United States
Message 4 of 5 (1,372 Views)

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

Thanks,

 

Andrew

Please use plain text.
New Member
TerryB99
Posts: 1
Country: Australia
Message 5 of 5 (1,342 Views)

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

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 

 

 

Please use plain text.