Extracting particular data in substring but location is never the same place

[kgarland17]

I have tens of thousands of SKUs and I need to be able to pull a particular attribute from them all into one column but the attribute is never in the same location across all the SKUs.
How does/can one pull a 1-3 digit number w/ the same letter after it?

example: need to extract the bold data

REST-B-AQ-3FD-6Z-32V-DE-XX VRZA-B-16Z-29SR-1G-HR-XS-XX DELI-B-XP-F5S-5W-22-BW-155Z-XX

 

[shaowu459]

Interesting formula! I have not seen VDB() used before. Could it be tweaked in case these are possible?

kgarland.xlsm
	A	B
10	B-000891Z-36Z	000891Z
11	B6-1E1Z-123Z	1E1Z
Sheet1

Cell Formulas
Range	Formula
B10:B11	B10	=LET(s,TEXTSPLIT(A10,"-"),@FILTER(s,(RIGHT(s)="z")*ISNUMBER(VDB(,,999,0,--LEFT(s,LEN(s)-1))),""))

VDB used to identify whether a number falls between 0 and 999. If yes and the first parameter of VDB is 0 or ommited, VDB returns 0. If yes and the first parameter of VDB is greater than 0, VDB returns values between [0,the first parameter], which means the depreciation caculated between the periods 0~the number we tested. If the number we tested greater than 999, VDB retunrs #NUM! error.

工BOOK2.xlsx
	A	B	C
1	0	0	=VDB(,,999,0,A1)
2	999	0	=VDB(,,999,0,A2)
3	45	0	=VDB(,,999,0,A3)
4	4567	#NUM!	=VDB(,,999,0,A4)
5
6	0	0	=VDB(1,,999,0,A6)
7	999	1	=VDB(1,,999,0,A7)
8	45	0.0862	=VDB(1,,999,0,A8)
9	4567	#NUM!	=VDB(1,,999,0,A9)
Sheet1

Cell Formulas
Range	Formula
B1:B4	B1	=VDB(,,999,0,A1)
C1:C4,C6:C9	C1	=FORMULATEXT(B1)
B6:B9	B6	=VDB(1,,999,0,A6)