how to copy matching text in excel into another cell

[zubair99]

Hi,
I need help on excel. I have 9000 rows with different length of text/description.

sample begin:
<p>-Input Power (Cells): 2-3S LiPo


-Brake: Proportional


-On Resistance, Brushless: 0.002 Ohm


-Continuous / Burst Current: 25 Amp / 90Amp


-Linear BEC: 5 Volts, 1 Amp


-Dimension: 30x26.1x13.8mm


-Weight: 26g


-Motor:4300kv</p>

sample end.

I want to extract weight only numbers as you can see above. problem is each row description text are different length so not any formula working which find
exact same space for each row. what is the function which extract and copy into weight colum.
please help
thanks

 

[Rick Rothstein]

Is the units for your weights always grams (g)?

 

[zubair99]

Not always but 90% are weight in gram(s).

 

[zubair99]

Anyone Please Help, I can't do this all manually.

 

[Rick Rothstein]

Not always but 90% are weight in gram(s).

Give this formula a try, put it in cell F2 and copy it down...

=IFERROR(LOOKUP(9E+307,--LEFT(MID(I2,SEARCH("weight:",I2)+7,99),ROW($1:$99))),"")

 

[zubair99]

Thank you its working you are great.
Thanks again for your great help.

 

[zubair99]

This excel forum is great.
Thanks Again