LinkBack URL
About LinkBacks
I have a list of over 5,000 names and addresses. The problem is that the city,state,zip part are in one cell but I need them to be split into three different columns. Ive attached a small sample of how it is now and how I need it to be. Please help
I have a list of over 5,000 names and addresses. The problem is that the city,state,zip part are in one cell but I need them to be split into three different columns. Ive attached a small sample of how it is now and how I need it to be. Please help
In C2
=LEFT(A2,FIND("-",A2)-9)
In D2
=MID(A2,FIND("-",A2)-8,2)
in E2
=RIGHT(A2,LEN(A2)-FIND("-",A2)+6)
Then copy down
Martin
Martin's formulas work..
Perhaps in E2 you might simply wanna use
considering the consistent length of zip codes
Please Login or Register to view this content.
Life's a spreadsheet, Excel!
Say thanks, Click *
Hi beezer2484
Not knowing if your Zip code are the same length or if the city has more then 2 words see the attached.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks