Pull City out of Address

I have an address is the form of:

8065 Elk Grove Florin Road, Sacramento, CA 95829

I would like to pull the City out. It is always the part in between the two comma's. Any way to pull the city out?

Chris
cansevinAsked:
Who is Participating?
 
Wayne Taylor (webtubbs)Commented:
=TRIM(MID(A1, FIND(",", A1)+1, FIND(",", A1, FIND(",", A1)+1)-FIND(",", A1)-1))

...where cell A1 contains the full address.
0
 
cansevinAuthor Commented:
Thanks!
0
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.