What function can delete everything before and after in a string?
So for the following example, how can I delete the string "http://www.excelforum.com/newthread.php?do=" and everything after the "&" like "&ip=123.1.865&date=1208"
I only want words between the first = and first & in the strings below. Without the + signs would be very helpful.
Please Login or Register to view this content.
Any help would be soo much appreciated!
Last edited by jcholla; 12-08-2010 at 12:25 PM.
This will give you the words/characters between the first = and + : it assumes that + is after =
=MID(A1,FIND("=",A1)+1,FIND("+",A1)-FIND("=",A1)-1)
edvwvw
Is this what you need ?
Please Login or Register to view this content.
i may have done something wrong, but that did not work for me.Originally Posted by edvwvw
this worked for me beautifully. thank you very much! +repsIs this what you need ?
Please Login or Register to view this content.
another alternative (FWIW)
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks