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
Please don't re-post.
You have an answer in your other identical but more recent post.
Please mark this as Solved and, ideally, cross refer to the other post.
Regards, TMS
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
Thanks TMS.
Cmb80,
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks