Seperating and extracting text from parentheses

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.
 
N

Niek Otten

In B1:

=LEFT(A1,FIND("(",A1)-1)

In C1:

=MID(A1,FIND("(",A1)+1,LEN(A1)-FIND("(",A1)-1)
 
R

Roger Govier

Hi Morton

B1 =LEFT(A1,FIND("(",A1)-1)
C1 =SUBSTITUTE(MID(A1,FIND("(",A1)+1),")","")
I can't tell form your posting whether there is a space between the last
digit and (.
If there is, then use -2 in the first formula
 
R

Ron Rosenfeld

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.

B1: =TRIM(LEFT(A1,FIND("(",A1)-1))
C1: =MID(A1,FIND("(",A1)+1,FIND(")",A1)-1-FIND("(",A1))

and fill down.
--ron
 
R

Roger Govier

Apologies.
For the second time today I managed to miss out part of the Mid() function.
That should have read
=SUBSTITUTE(MID(A1,FIND("(",A1)+1,LEN(A1)),")","")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top