Hello all, I extract data from a text string. Firstly it looks for text to the left of a "-" (code below)
What i want to do is extract the text from the right of ">" also. I have the code below - but don;t know how to combine the two into a workable formula.
Please Login or Register to view this content.
So if the text string in B11 read as abcd>efghij - klmnop I would want to extract efghijPlease Login or Register to view this content.
Hope that someone can help with this
hi cmb80. try:
=TRIM(MID(A1,FIND(">",A1)+1,FIND("-",A1)-FIND(">",A1)-1))
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
Spot on - 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