Dear all,
If I have in a cell a sentence for example Feras has more than 100 Dollars, how can I use a formula to get rid out of the words and keep only the number before the Dollars word. Because I have a column which contains of cells filled by a lot of string type and I'm interested in having only the number which is always coming before the Dollars words.
So I want a tool to give me from this input Feras has more than 100 Dollars, this output 100 Dollars.
Thanks in advance for your kind support.
Solved! Go to Solution.
@Feras95p
Glad to help and thank you for the accept mark.