Hi Puzzled,

If your data remains exactly like your example then all you need
is =RIGHT(A1,25) in B1 and drag down as far as needed.
(that's assuming your data is in A1 down)

If your data is likely to change slightly such as
DEERFIELD BCH, FL 33441
DEERFIELD BCH, FLORIDA 33441
etc.
Then you will need a slightly different approach.

HTH
Martin


"Puzzled" wrote in message
...
This should not be a hard thing to do, but I can't get it. the city will
always be the same with only 2 different zips.

Example: 1957 NE 6 ST DEERFIELD BEACH, FL 33441
2430 DEER CREEK C C BLVD APT 702-11 DEERFIELD BEACH, FL 33442

looking to extract "DEERFIELD BEACH, FL 33441" and move to the blank cell
to
the right?

I want to create labels. Help would be greatly appreciated.