Try this:
=MID(A1,FIND("DEERFIELD",A1),99)


"Puzzled" wrote:

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.