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.
<tbody>
</tbody>
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>