Community
Showing results for 
Search instead for 
Do you mean 
Reply

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

New Member
Posts: 5
Country: United States

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

New Member
Posts: 5
Country: United States

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

Platinum Elite Contributor
Posts: 6,437
Country: USA

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
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
New Member
Posts: 5
Country: United States

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

Thanks,

 

Andrew

New Member
Posts: 1
Country: Australia

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