Try this...

A1 = VIRGINIA BEACH VA

B1 = extracted state:

=RIGHT(A1,2)

To extract the city:

=SUBSTITUTE(A1," "&B1,"")

--
Biff
Microsoft Excel MVP


"syl_usmc" wrote in message
...
I have a column with STATE & CITY information i.e. A1= VIRGINIA BEACH VA,
A2=YAKIMA WA, A3=RENO NV, etc. I'm able to extract the STATE digits using
the
'right' function; however, I can't do the same for the CITY information
due
to the different lenghts. Is there a formula to do this?
Please help.