I didn't, but should have, tested.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rick Rothstein" wrote in message
...
You didn't like my macro? :-(

Only kidding. <g

Actually, though, both Mike's and my macros didn't handle the phone number
reformat the that the OP also wanted (see the "Needed Results" from his
sample data). I just posted a modification to my macro which handles the
comma and the phone number... I presume Mike will follow up with a
modification to his own macro.

--
Rick (MVP - Excel)


"Don Guillett" wrote in message
...
Then use Mike's

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Maverick50" wrote in message
...
One Column

"Don Guillett" wrote:

Is it all in ONE column or in 3?
If in columns just use left and , and right len-8 for 2 char st and 5
char
zip.
if all in one column use select case for states and instrREV
??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Maverick50" wrote in message
...
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