spell out state name from an abbreviation
 

I am entering an abbreviation of a state (along with a city name) in one cell
& needing it to spell out just the state name (fully) in a different cell
within the same excel workbook. How do I do this? Is there a program out
there that I can use? I need this to work on all the states.

In another location, perhaps a second sheet (say, sheet2), enter the
abbreviations and states:

A B
1 AL Alabama
2 AK Alaska
3 ...

Then, assuming your abbreviation is entered in sheet1, cell D1, use
VLOOKUP:


=VLOOKUP(D1, Sheet2!A:B, 2, FALSE)


In article ,
julieb wrote:

I am entering an abbreviation of a state (along with a city name) in one cell
& needing it to spell out just the state name (fully) in a different cell
within the same excel workbook. How do I do this? Is there a program out
there that I can use? I need this to work on all the states.

Use a VLOOKUP on the list below. You can place the list in your worksheet
and hide it or on a separate worksheet. You must use FALSE to get the
correct state name. =VLOOKUP(A1,$A$1:$A$50,2,FALSE)
Good Luck
Pat F

AL ALABAMA
AK ALASKA
AZ ARIZONA
AR ARKANSAS
CA CALIFORNIA
CO COLORADO
CT CONNECTICUT
DE DELAWARE
DC DISTRICT OF COLUMBIA
FL FLORIDA
GA GEORGIA
HI HAWAII
ID IDAHO
IL ILLINOIS
IN INDIANA
IA IOWA
KS KANSAS
KY KENTUCKY
LA LOUISIANA
ME MAINE
MD MARYLAND
MA MASSACHUSETTS
MI MICHIGAN
MN MINNESOTA
MS MISSISSIPPI
MO MISSOURI
MT MONTANA
NE NEBRASKA
NV NEVADA
NH NEW HAMPSHIRE
NJ NEW JERSEY
NM NEW MEXICO
NY NEW YORK
NC NORTH CAROLINA
ND NORTH DAKOTA
OH OHIO
OK OKLAHOMA
OR OREGON
PW PALAU
PA PENNSYLVANIA
RI RHODE ISLAND
SC SOUTH CAROLINA
SD SOUTH DAKOTA
TN TENNESSEE
TX TEXAS
UT UTAH
VT VERMONT
VA VIRGINIA
WA WASHINGTON
WV WEST VIRGINIA
WI WISCONSIN
WY WYOMING


"JE McGimpsey" wrote:

In another location, perhaps a second sheet (say, sheet2), enter the
abbreviations and states:

A B
1 AL Alabama
2 AK Alaska
3 ...

Then, assuming your abbreviation is entered in sheet1, cell D1, use
VLOOKUP:


=VLOOKUP(D1, Sheet2!A:B, 2, FALSE)


In article ,
julieb wrote:

I am entering an abbreviation of a state (along with a city name) in one cell
& needing it to spell out just the state name (fully) in a different cell
within the same excel workbook. How do I do this? Is there a program out
there that I can use? I need this to work on all the states.