Need help with a city State Zip rule in Formatting Text Posted July 15, 2011 Needing help with a rule that does the following: For the city it needs to Force UC the first letter and force LC the remaining letters in the city with a comma coming directly after. For the state it needs to Force UC the state initials with no comma after the state and before the zip. Final format should look like this: Cordova, TN 38018 I am still pretty new at all this so any help would be greatly appreciated. -Jason
Need help with a city State Zip rule
in Formatting Text
Posted
Needing help with a rule that does the following:
For the city it needs to Force UC the first letter and force LC the remaining letters in the city with a comma coming directly after.
For the state it needs to Force UC the state initials with no comma after the state and before the zip.
Final format should look like this:
Cordova, TN 38018
I am still pretty new at all this so any help would be greatly appreciated.
-Jason