» Splitting a Full Address into Three Separate Cells
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
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)

Book Store:
Recommended Books:
- Special Edition Using Microsoft Access 2002
- Mastering Excel 2000 (for beginner)
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Excel Charts
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
No comments have been submitted.


