Extracting value using vlookup from a cell

[superboy]

Hello,

In cell A2 I have "Product name, listing id, Qty: 2" and In cell B2, I will like to be able to use Vlookup or any function to extract Qty :2. I want cell B2 to reflect the quantity 2. I get the feeling this is relatively easy to do but I am self thought and I will appreciate any help. Thank you.

 

[AhoyNC]

The formulas below assume that the value is always at the end of your text string.
If the value will never be over 2 digits you could use the formula in C1.

If the value could be over 2 digits then use the formula in B1 (this formula assumes that the value will have Qty: in front of it.

Excel Workbook
	A	B	C	D
1	Product name, listing id, Qty: 2	2	2
Sheet2

 

[István Hirsch]

Try this formula if the number is at the end of the string and is not higher than 10^10:

=LOOKUP(10^10,1*RIGHT(A1,{1,2,3,4,5,6,7,8,9,10}))

 

[superboy]

Hello,

I will first and foremost like to thank you all for your help in solving this issue. I have but one question on how to edit your function. The example given to you was an example but for something like the data below.

How will I edit this =RIGHT(A1,LEN(A1)-SEARCH("Qty:",A1)-4)+0
I tried on my own but failed, I could only remove the "+0" and get the quantity value but it came with the asin and sku too


111-111111-11111
SONY REMOTE
QTY: 1 ASIN: B000000000 SKU: 00-0000-0000

 

[AhoyNC]

See if this works for you.

Excel Workbook
	A	B	C
1	SONY REMOTE QTY: 1 ASIN: B000000000 SKU: 00-0000-0000	1
2
Sheet1

 

[superboy]

Thank you. It works.