Hello guys, how can i take the number only from the address and sort it?
Example:
A
A B 1 NUMBER ADDRESS 2 NO_5, St Road 3 NO_13, St Road 3 NO_333, Alice Rd
to become
A B 1 NUMBER ADDRESS 2 5 NO_5, St Road 3 13 NO_13, St Road 3 333 NO_333, Alice Rd
Sorry for troubling.
Enter formula in A2 and copy down
Formula:
Please Login or Register to view this content.
v A B 1 NUMBER ADDRESS 2 5 NO_5, St Road 3 13 NO_13, St Road 4 333 NO_333, Alice Rd
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
hi azrul94. another alternative:
=--MID(REPLACE(B2,FIND(",",B2),LEN(B2),""),FIND("_",B2)+1,LEN(B2))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
=--substitute(left(b2,find(",",b2)-1),"no_","")
Its working guys. Thank you ^^
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks