REGEX_Replace

[Feras95p]

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.

[Qiu · Accepted solution]

@Feras95p 

Something like this?

[Feras95p]

Hi @Qiu, 

Yes exactly! Thanks for helping.

[Qiu]

@Feras95p 
Glad to help and thank you for the accept mark.