Searches cell for number string contained in parenthesis, returns number string

[billyheanue]

Hi all, I am wondering how to construct a formula that checks cells (e.g A2, A3, A4...and so on) for certain characters (parenthesis), and returns a number string held in these parenthesis - if it finds them!

For instance, I have:

[TABLE="width: 265"]
<colgroup><col></colgroup><tbody>[TR]
[TD]COFFEE ROASTER, 6110100, W/BLACK[/TD]
[/TR]
[TR]
[TD]BASE AND CLEAR LID, 100/CS (49034)[/TD]
[/TR]
</tbody>[/TABLE]

in cells A2: (COFFEE ROAST....)
and A3: (BASE AND....)


I want a formula, say in cell C2 (C3,C4...and so forth), that checks the contents of A2 (A3,A4, ...and so forth) for parenthesis (), and returns the number inside them.

E.g Cell C3 would find (49034) and return "49034".


Thanks all!

 

[RonB1111]

Try:

=IFERROR(MID(A2,FIND("(",A2)+1,FIND(")",A2)-FIND("(",A2)),"")

 

[Arul.rajesh]

use the formula =MID(A2,FIND("(",A2)+1,FIND(")",A2)-FIND("(",A2)-1)