Expand Abbreviations For State Names
No worries. From his response, sounds like he's happy (as well as cryptic).
Fred
"JLatham" wrote in message
...
Fred, just to clarify why I provided what I did: he specifically asked for
a
macro. Additionally, I wasn't sure just exactly HOW he wants to use it,
and
that's the reason I came back with the Sub, which could be adapted to use
with a worksheet also.
I agree with you that a VLOOKUP() with a table is much simpler (and in
this
case would be much faster).
Sometimes we just don't get quite enough info to give a "spot on" answer,
do
we? At least with your input, and JPs, hopefuly Questor now has an option
available that will work for him/her.
"Fred Smith" wrote:
Most people would use Vlookup for this. Create a table of the 50 states
and
their "English" names. Then use a formula like:
=vlookup(a1,States!A:B,2,false)
Regards,
Fred
""Questor"" wrote in message
...
I am looking for a macro that converts US Post Office abreviations for
State
Names into plain English. If one is available please advise.
Thank you,
Questor
.
|