How to extract Part Number from Excel spreadsheet?

Question

excel

The layout is next.
From the table it is necessary to select P / N parts with a random set of characters.
Conditional view next
Battery LITHIUM PMX165 C 3,9V
6,2AH 5H-AA2000B
Rechargeable battery B 22/5.2 HILTI
Power battery LS14500 3.6V "SAFT"
Additional battery pack SURT192XLBP
Power supply 24V DR-60W-24 EKF PRO
Power supply HLG-240Н-54B
Power supply SFP12010000PE iRZ
Power supply UNO-PS/ 1AC/24DC/240W

Bold highlighted the numbers themselves. Presumably in such a number there are 2 letters and 2 numbers. Naturally, the number is separated from the text by spaces. How to display all numbers in a separate column ???

Answer 1

We must first understand - what are the patterns. Offhand I see:
1. First comes the Cyrillic description text, then PartNumber;
2. PartNumber goes without spaces;
3. PartNumber always contains uppercase Latin letters and numbers (with a slash or a hyphen);
4. PartNumber is longer than 3 characters;
Already on these grounds, you can create a simple function that selects PartNumber from the full name.
Further manual analysis of the results is required.
If there is a resource for checking the existence of the received PartNumber, then the analysis task is greatly simplified.