=Left or =Find?

[mn1t12]

I have a list of Item ID's and descriptions in one cell.

The descriptions are in (...) in each cell.
What is the formula to pick out the text that is not in the (...)?
The length of the text not in (...) varies from cell to cell

See examples below.

RGPR-WPC80 (WPC 80)

RGEV (Evodiamine 10%) So for the 1st line above, output = RGPR-WPC80 thx! mn

<tbody>
</tbody>

 

[Joe4]

If the description always appears at the end like that and there is nothing else after it, try:

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

 

[FryGirl]

To extract text between ()

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

Not sure it's clear what you want beside the text within ()?

Sorry, misread the "not" part

 

[ORoxo]

I have a list of Item ID's and descriptions in one cell.

The descriptions are in (...) in each cell.
What is the formula to pick out the text that is not in the (...)?
The length of the text not in (...) varies from cell to cell

See examples below.

RGPR-WPC80 (WPC 80)

RGEV (Evodiamine 10%) So for the 1st line above, output = RGPR-WPC80 thx! mn

<tbody>
</tbody>

If the description always appears at the end you may also use

=MID(G6;1;FIND("(";G6)-1)