Hi Everyone
Does someone know the formula that extracts a specific word from the sentence??
I have a file index in my workbook (example) "WOPR2230 Operating X-ray scanner v3 14032014","WOPR2231 Operating volume scanner v2 14032014" I would like to extract only v and the number attached to it...
Thanks a lot for all help
Dan
Not sure how many numbers you will have after the "v", but try this, it will pull out up to v9...
=MID(A1,SEARCH(" v? ",A1,1)+1,3)0
edit: this will go up to v99...
=MID(A1,IFERROR(SEARCH(" v? ",A1,1),SEARCH(" v?? ",A1,1))+1,3)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Very similar to Ford's suggestion, but this should find any length number attached to the "v"
=TRIM(MID(SUBSTITUTE(A2," ", REPT(" ",20)), FIND(" v", SUBSTITUTE(A2," ", REPT(" ",20))), 20))
And if there's a chance the "v" word would be missing:
=IFERROR(TRIM(MID(SUBSTITUTE(A2," ", REPT(" ",20)), FIND(" v", SUBSTITUTE(A2," ", REPT(" ",20))), 20)), "none")
_________________
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!)
Jerry, that doesnt work for the 2nd sample (contains a word with "v" - volumne)
Hi Everyone :-)
I just want to quickly thatnk each one of you for taking time to help me with it.
All of your solutions working well and I will choose one that suits my project best.
Once again Thank you
Dan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks