Excel: Extract City & State from string

I have data in one cell and need to extract in column B the city & state Any suggestions? Before 2330 Tittabawassee Rd Saginaw MI 48604 22600 Hall Rd #204 Clinton Twp MI 48036 3254 Stadium Dr Suite B Kalamazoo MI 49008 3446 S Linden Rd Flint MI 48507 5122 E Lincoln Hwy Merrillville IN 46410 555 S. Reynolds Rd Toledo OH 43615 1037 North Michell St Cadillac MI 49601 47178 Hayes Rd. Macomb MI 48044 After Saginaw MI Clinton Twp MI Kalamazoo MI Flint MI Merrillville IN Toledo OH Cadillac MI Macomb MI

This question generated 16 answers. To proceed to the answers, click here.

This thread is current as of June 17, 2015.

For more resources for Microsoft Excel