Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
New Member
Burger108
Posts: 5
Country: United States
Message 1 of 5 (1,409 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

New Member
Burger108
Posts: 5
Country: United States
Message 2 of 5 (1,407 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

Platinum Elite Contributor
Roy_Laudenslage
Posts: 5,759
Country: United States
Message 3 of 5 (1,407 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
New Member
Burger108
Posts: 5
Country: United States
Message 4 of 5 (1,403 Views)

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

Thanks,

 

Andrew

New Member
TerryB99
Posts: 1
Country: Australia
Message 5 of 5 (1,373 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