Extracting numbers from Text

**ViolaM** · 02-15-2015, 06:56 AM

Hi Guys

Need help. I need to extract numbers which are among text such as the following:

Vendas 440kgs s/2
Vendas 240kgs s/2
Vendas 160kgs s/2
Vendas 210kgs s/3
Vendas 80kgs s/4
Vendas 80kgs s/4
Vendas 1341.5kgs s/4
Vendas 75kgs s/4
Vendas 205kgs s/4
Vendas 320kgs s/4
Vendas 402.5kgs s/4
Vendas 418.5kgs s/5
Vendas 404kgs s/5
Vendas 45kgs s/5
Vendas 978kgs s/5
Vendas 959kgs s/5

I need to do this without using Text to Columns because its cutting my data in different places.

Please help

**oeldere** · 02-15-2015, 06:59 AM

And what should be the result?

**ViolaM** · 02-15-2015, 08:46 AM

The results should be:

Column A Column B Column C
Vendas kgs S/2(week 2)

Thanks

**Glenn Kennedy** · 02-15-2015, 08:46 AM

It's not that clear what you want as a result, but this will return the number of kgs, as a number and not as text. Assumes data start in A1.

=LEFT(SUBSTITUTE(A1,"Vendas ",""),FIND("kgs",SUBSTITUTE(A1,"Vendas ",""))-1)+0