Tip Printed from ExcelTip.com

---

Splitting a Full Address into Three Separate Cells


Problem:

Separating the addresses shown in column A into three columns, one each for City, State, and Zip Code.

Solution:

Use the LEFT, MID, RIGHT, and FIND functions as shown in the following formulas:
To extract the City: =LEFT(A2,FIND(",",A2)-1)
To extract the State: =MID(A2,FIND(",",A2)+2,2)
To extract the Zip code: =RIGHT(A2,5)