M
Morton Detwyler
I receive hundreds of rows of text data for part numbers and part
descriptions. The data is in a row format, beginning in A1, A2, A3, etc.
The data in each row is one text string; e.g.
Cell A1 - 123456-789 (PNL, 15.4 WXGA BV, RoHS, LPL)
Cell A2 - 57CX4962012 (LCD INVERTER)
I would like to separate the data in each of the text strings into the
format below. I've had a real challenge with extracting the part description
from the parentheses.
Cell A1 Cell B1
Cell C1
123456-789 (PNL, RoHS, LPL) 123456-789 PNL, RoHS, LPL
Cell A2 Cell B2
Cell C2
57CX4962012 (LCD INVERTER) 57CX4962012 LCD INVERTER
Thank you for your time and assistance.
descriptions. The data is in a row format, beginning in A1, A2, A3, etc.
The data in each row is one text string; e.g.
Cell A1 - 123456-789 (PNL, 15.4 WXGA BV, RoHS, LPL)
Cell A2 - 57CX4962012 (LCD INVERTER)
I would like to separate the data in each of the text strings into the
format below. I've had a real challenge with extracting the part description
from the parentheses.
Cell A1 Cell B1
Cell C1
123456-789 (PNL, RoHS, LPL) 123456-789 PNL, RoHS, LPL
Cell A2 Cell B2
Cell C2
57CX4962012 (LCD INVERTER) 57CX4962012 LCD INVERTER
Thank you for your time and assistance.