| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find & Replace Multiple State abbreviations
I have multiple State abbreviations with no comma. How do I add the comma
with all the state abbreviations? I have been doing it separately€¦very time consuming. Find what: WY Replace with: , WY Actual 4915 N Federal Highway<brLighthouse Point FL 33064<brPhone: 9544809085 11 West 2ND Avenue<br<brWilliamson WV 25661<brPhone: 3042355659 10673 W Street<br Charles Road<brSumner MI 48889<brPhone: 9898332265 Needed Results 4915 N Federal Highway<brLighthouse Point, FL 33064<brPhone: 954-480-9085 11 West 2ND Avenue<br<brWilliamson, WV 25661<brPhone: 304-235-5659 10673 W Street<br Charles Road<brSumner, MI 48889<brPhone: 989-833-2265 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| State names into abbreviations | Excel Worksheet Functions | |||
| replace state names with state code abbreviations | Excel Worksheet Functions | |||
| state abbreviations | New Users to Excel | |||
| Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
| US State Abbreviations List | New Users to Excel | |||
Threaded Mode
