Find a word combination of letters and numbers

[nburaq]

Hi,

I have a data set of descriptions and I need to find words in descriptions combined with numbers and letters. As an example cell A2 includes a sentence "Repair A4040D" so cell B2 should include information "A4040D". The equipment number is combination of letters and numbers max of 6 characters. Is there any possibility to extract equipment information with any formula ?

Thanks for your help and comments!

 

[Peter_SSs]

One example is not enough to provide a reliable best method. Could we have 5-10 examples of what could be in column A and the corresponding expected results (preferably with XL2BB so that we can easily copy to test with)
Ensure that the col A samples demonstrate any sort of variations that can occur in that column.

 

[nburaq]

One example is not enough to provide a reliable best method. Could we have 5-10 examples of what could be in column A and the corresponding expected results (preferably with XL2BB so that we can easily copy to test with)
Ensure that the col A samples demonstrate any sort of variations that can occur in that column.

Thanks for quick reply. Since this is not personal pc, there is no option to install XL2BB. But I would like to share small data set. In column B, you will see what I want to achieve with formula.(end result) if there is no combination of letters and numbers in description it means there is no equipment described.

Description	Equipment
Broken belt of C210	C210
Bearing replacement A601d	A601D
Bad product. Waited for new product
A522 chain replacement + B117 shaft repair	A522, B117
Damaged engine A400	A400
Startup problems C505 (No feeding)	C505
Problems with pump
Leakege problem of pump 155D	155D
Broken rail B100/A/B	B100/A/B
A1212 and A1213 no electricity	A1212,A1213

Thanks again!

 

[Peter_SSs]

Thanks for the sample data - it certainly shows that the one example in post 1 was insufficient to understand the full requirement.

See if this helps.

23 12 12.xlsm
	A	B
1	Description	Equipment
2	Broken belt of C210	C210
3	Bearing replacement A601d	A601d
4	Bad product. Waited for new product
5	A522 chain replacement + B117 shaft repair	A522, B117
6	Damaged engine A400	A400
7	Startup problems C505 (No feeding)	C505
8	Problems with pump
9	Leakege problem of pump 155D	155D
10	Broken rail B100/A/B	B100/A/B
11	A1212 and A1213 no electricity	A1212, A1213
Equip No

Cell Formulas
Range	Formula
B2:B11	B2	=TEXTJOIN(", ",1,BYCOL(TEXTSPLIT(A2," "),LAMBDA(c,IF(COUNT(FIND(SEQUENCE(10)-1,c))>0,c,""))))

 

[nburaq]

Thanks for the sample data - it certainly shows that the one example in post 1 was insufficient to understand the full requirement.

See if this helps.

23 12 12.xlsm
	A	B
1	Description	Equipment
2	Broken belt of C210	C210
3	Bearing replacement A601d	A601d
4	Bad product. Waited for new product
5	A522 chain replacement + B117 shaft repair	A522, B117
6	Damaged engine A400	A400
7	Startup problems C505 (No feeding)	C505
8	Problems with pump
9	Leakege problem of pump 155D	155D
10	Broken rail B100/A/B	B100/A/B
11	A1212 and A1213 no electricity	A1212, A1213
Equip No

Cell Formulas
Range	Formula
B2:B11	B2	=TEXTJOIN(", ",1,BYCOL(TEXTSPLIT(A2," "),LAMBDA(c,IF(COUNT(FIND(SEQUENCE(10)-1,c))>0,c,""))))

It works like charm! Thanks a lot and I agree that more data was absolutely required.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.