Extracting text/numbers after a specific text

[silverkay]

Hi all,

I am looking for help with regard to extracting text/numbers after a specific text in Excel, below are two examples

"Manufacturer Silver Tire Width 205 Dia 21 Qty 1"
"Manufacturer Rubber Tire Width 213 Dia 23 Qty 3"

I am looking to extract
1) Text after "Manufacturer", e.g. "Silver" or "Rubber"
2) Number after Width, e.g. 205 or 213
3) Number after Dia, e.g. 21 or 23
4) Number after Qty. 1 or 3

Any help will be greatly appreciated, thank you!

 

[Peter_SSs]

Try this, in a blank cell enter

=LET(abc,3+4)

That is not a valid formula. It would need to be something like

=LET(abc,3+4,abc)

 

[Fluff]

I couldn't figure out how to work around the LET function, and I got #NAME even when I copypasted the formula directly.

As has been said, you may not have the LET function yet, in which case my suggestion would become.

+Fluff 1.xlsm
	A	B	C	D	E
1		Manufacturer	Width	Dia	Qty
2	Manufacturer Silver Tire Width 205 Dia 21 Qty 1	Silver	205	21	1
3	Manufacturer Rubber Tire Width 213 Dia 23 Qty 3	Rubber	213	23	3
Data

Cell Formulas
Range	Formula
B2:E3	B2	=LEFT(MID($A2,FIND(B$1,$A2)+LEN(B$1)+1,99),FIND(" ",MID($A2,FIND(B$1,$A2)+LEN(B$1)+1,99)&" "))

 

[silverkay]

As has been said, you may not have the LET function yet, in which case my suggestion would become.

+Fluff 1.xlsm
	A	B	C	D	E
1		Manufacturer	Width	Dia	Qty
2	Manufacturer Silver Tire Width 205 Dia 21 Qty 1	Silver	205	21	1
3	Manufacturer Rubber Tire Width 213 Dia 23 Qty 3	Rubber	213	23	3
Data

Cell Formulas
Range	Formula
B2:E3	B2	=LEFT(MID($A2,FIND(B$1,$A2)+LEN(B$1)+1,99),FIND(" ",MID($A2,FIND(B$1,$A2)+LEN(B$1)+1,99)&" "))

This worked well! Thank you for your help.

 

[Fluff]

Glad we could help & thanks for the feedback.