Seperating and extracting text from parentheses
 

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.

Seperating and extracting text from parentheses
 

In B1:

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

In C1:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Morton Detwyler" wrote in
message ...
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.

Seperating and extracting text from parentheses
 

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
--
Regards
Roger Govier

"Morton Detwyler" wrote in
message ...
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.

Seperating and extracting text from parentheses
 

On Tue, 10 Feb 2009 09:09:01 -0800, Morton Detwyler
wrote:

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

Seperating and extracting text from parentheses
 

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)),")","")

--
Regards
Roger Govier

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
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
--
Regards
Roger Govier

"Morton Detwyler" wrote in
message ...
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.