10-22-2012 05:52 AM
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?
10-22-2012 06:15 AM
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.