01-22-2009 02:01 PM
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.
01-22-2009 02:04 PM
01-25-2009 05:13 AM
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