View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maverick50 Maverick50 is offline
external usenet poster
 
Posts: 5
Default 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