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
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