billyheanue
Board Regular
- Joined
- Jul 13, 2015
- Messages
- 109
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!
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!