I am trying to extract all the text in this string which occurs after /en-us/
http://advertising.microsoft.com/wwd...d-in/setup.exe
so that it looks like this
advertise/add-in/setup.exe
If possible, from the remaining string, I would like to replace all forward slashes with a space and format all remaining words with the =Proper format.
Any thoughts?
If it's in cell A1, try:
=PROPER(SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("en-us",A1)-5),"/"," "))
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
My version:
=MID(A1, FIND("/en-us/", A1)+7, LEN(A1))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
@JBeaucaire: well, it's shorter than mine ... but it doesn't do the formatting the OP asked for ;-)
Heh, I completely missed the second question. your technique is best for that.
thank you all!!
You're welcome.
If this has answered your question, please mark the thread as solved. See my signature for details or the FAQ.
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks