|
|
#2
11-10-2014, 10:21 PM
|
|||
|
|||
Assuming that all of your addresses have 5 digit zipcodes and 2 character states you can use a combination of mid, right, and len formulas to do this quite easily.
The following formulas start with addresses in cell A2 Code:
For the City: =MID(A2,1,LEN(A2)-9) For the State: =MID(A2,LEN(A2)-7,2) For the Zip: =RIGHT(A2,5) Thanks 
|
| Tags |
| address, function, separate |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Suppress comma in "city , stat zip" line when blank
|
DHammer | Mail Merge | 1 | 05-30-2014 02:43 AM |
|
No inverted commas in word 2013.
|
tonycrossley | Word | 3 | 01-27-2014 04:55 PM |
|
mail merge treating CITY as DATE
|
woody | Mail Merge | 6 | 01-30-2013 03:22 PM |
|
Merge to Seperate Documents
|
joughin | Mail Merge | 1 | 05-17-2012 05:08 PM |
| Seperate Column widths in one worksheet | miller.3276 | Excel | 2 | 01-27-2010 02:12 PM |
Windows 7 64bit 
Office 2003
Threaded Mode