Hello,
I'm looking to Extract a Number from the Middle of a String with a Variable # of Words.
The number I need is the number that's before either of the following words that may apprear in the string....
"Bar Silver"
"Bar Platinum"
"Coin Silver"
"Coin Gold"
"Certified Coin Gold"
"Bar Gold"
This is a formula that I have been trying to work with, and I'm able to extract everything to Left of the number that I want, but not able to isolate the number itself.
=TEXTBEFORE(A4,{"Bar Silver","Bar Platinum","Coin Silver","Coin Gold","Certified Coin Gold","Bar Gold"})
The first 4 numbers that I'm looking to extract are....
82
5
4
10
It doesn't need to be using this formula.
Any help would be highly appreciated.
Thank you!
Robert
Bookmarks