Pull City out of excel

I have a column of addresses that are all in this form:

"11493 East Rosehedge Dr
Whittier, CA 90606"

After the "Enter" and before the first Comma is the City. I want to pull just the city out of the cell in the next column. Any idea? First on is in Cell C2.
Who is Participating?
barry houdiniConnect With a Mentor Commented:
Try this formula in D2 copied down


regards, barry
cansevinAuthor Commented:
Worked great, thansk!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.