LinkBack URL
About LinkBacks
Resolved
Thank you so much!
Resolved
Thank you so much!
Last edited by sinaranje; 12-21-2014 at 06:34 PM.
For names try this formula in E4 and pull it to the right
=SUBSTITUTE(TRIM(MID(SUBSTITUTE($A4," ",REPT(" ",255)),(COLUMNS($A:A)-1)*255+1,255)),",","")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you for the great suggestion.
No need for suggestion on help with names, I got that done. The addresses are the biggest problem because each are packed into their individual cells with no real indicators such as commas to separate the information into....
Address Line 1 | Suite # | City | State | Zip
Please HELP!
Unfortunately, the addresses contain different number of words and there is no way for excel to differentiate between them.
you address are separated by alt-enter (char(10)
maybe you can use the =SUBSTITUTE(B4,CHAR(10),",") to substitute them with comma then perform the extraction
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
This will take you a little bit along the way. The names are straightened out. Someone else did too. I have tackled the addresses and have gotten the ZIP CODES (some were not 10 characters), the State, and "most" of the cities. The variance in the number or rows throws some of the CITIES into chaos.
Canadian addresses are another matter. They just don't fit. They should probably be filtered out and treated separately.
I have worked from right to left to narrow down what to extract.
Anyway, this is what I have for you.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
I am working on a User Defined Function for the Addresses.
That is the only way ahead for the Addresses.
Line 1 and Line 2
Everything else is solvable using using formulas.
This will take a couple of days.
Last edited by mehmetcik; 12-19-2014 at 10:51 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
I am working on a User Defined Function for the Addresses.
That is the only way ahead for the Addresses.
This is about as far as I can go. I have isolated American cities, State and Zip as well as the names.
Resolved!!
Thank you for the feedback.
Can you share with us the solution?
Please mark the thread Solved....use the thread tools above the first message.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks