separate numbers from rest of the text

[andonny]

Hi,
I need to separate the numbers which appear at the end of a text and they are in brackets. I usually use the function below to do that. Latley somebody started to add numbers into two brackets and then it doesn't work anymore.

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

These are the different type of text which can be in cells.

Abc test1(12) (1234)
bbc test2 (1) (12345)
ddd test2 (123456)
etc.

Result:
1234
12345
123456

Your help is very much appreciated
Andonny

 

[sen_edp]

(parenthesis).xls
	A	B	C	D	E	F	G	H
1	test(12)(1452)	6	11	1452	16	5	1452	1452
2	(333)(1223)	1	7	1223	12	5	1223	1223
3	demo(123)(123456)	5	11	123456	18	7	123456	123456
4	andreas(1)(12)	8	11	12	14	3	#VALUE!	12
Sheet1

Thanks Aladin

 

[Dave Patton]

try the Morefunc

=-(WMID(A9,-1,2,CHAR(41)))

It should leave the last number

with no spaces
"test2(2)(12345)" left 12345

If there are spaces, try
=-(WMID(A2,-1,1,""))