Not sure if this is possible. I have about 600 records that have the entire address of a business in an indivudual cell. For example:
A1= 1234 First St., Boston, MA 12345
A2=4567 2nd St., New Youk, NY 12345
Is there anyway to look at each cell and determine the state and have the sate inputted in the adajacnt cell? In other words B1=MA, B2=NY, etc. Bottom line is I'm trying to sort the list by the state code.
Assuming each state is preceded by a comma then
B1: =LEFT(TRIM(RIGHT(SUBSTITUTE(A1,",",REPT(" ",50)),50)),2)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
see the sample attached.
modytrane
Ah, do you always have 5 digits ? I wasn't sure !
Ha! Nothing like offering a hideously over engineered solution on a Friday - oops!
You guys are awesome.......thanks!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks