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
 

Hi,

In B1 to extract the first bit
=TRIM(LEFT(A1,FIND("(",A1)-1))

and the second bit

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

Mike

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

Seperating and extracting text from parentheses
 

Have you tried the Data Text to Columns Delimited Other: (


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=61756

Seperating and extracting text from parentheses
 

It worked perfectly! Thank you so much....

"Mike H" wrote:

Hi,

In B1 to extract the first bit
=TRIM(LEFT(A1,FIND("(",A1)-1))

and the second bit

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

Mike

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