Showing results for 
Search instead for 
Do you mean 

combining city, state and zip information

New Member
Posts: 7
Country: USA

combining city, state and zip information

Is there a way to combine the fields of city, state and zip into the address 3 field?  I need to export the information into Excel for a order form that I am using.  If I can't do it in ACT can I do it after I export it to Excel without doing it a contact at a time?



Silver Super Contributor
Posts: 2,329
Country: USA

Re: combining city, state and zip information

There isn't a way to do it in ACT! without using an addon but if you want to do it in Excel you just need to use this formula in an empty cell:  = A4 & A5 & A6


Where the columns A4, A5 & A6 are the City, State and ZIP Code fields.


After you create the first cell you can do a copy/paste and past it into the other cells in your new column.  Then you can copy the column and do a paste special and paste the values back on top of the contents of your new column so they don't go away if you delete the original columns from your Excel spreadsheet.



If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
Click Here to Purchase Act!