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

 

[My Aswer Is This]

So in this sample you only want to extract this:
-Weight: 26g

And what column might we find this in?
And you want to extrack it to where.
And when you say extrack does that mean remove from current location and put someplace else or:
Copy to someplace else

 

[zubair99]

I need to weight:xx numbers only into another column which is only has weight values. I need copy only not remove or replace.

colum1 colum2
copy here copy from here

 

[zubair99]

I am sending excel worksheet screenshot

 

[zubair99]

second screenshot

 

[zubair99]

anyone please help....

 

[My Aswer Is This]

Try this Vba script:
If your not sure how to install script let me know.

Sub Test()
Application.ScreenUpdating = False
Dim i As Integer
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "I").End(xlUp).Row
For i = 1 To Lastrow
If InStr(Cells(i, 9).Value, "Weight") Then
Cells(i, 6).Value = Cells(i, 9).Value
End If
Next
Application.ScreenUpdating = True
End Sub

 

[zubair99]

its not just copy weight value, it is copying whole cell text.

 

[zubair99]

I am sending you worksheet you can check.
https://copy.com/g2nvnVbhfm17ML7e

 

[My Aswer Is This]

I'm sorry I do not know how to extract just the weight value. Maybe someone else here at Mr. Excel can give you an answer.