Help with Formula to split a text

[rv02]

Hi All

I was wondering whther anyone can help me with the follwoing problem.

In Cell A1 & A2 I have a string which is
AAAAAAA (BBBBB) (D111)
BBBB (1804)
What I need to do in cell B1 to have a formula which will split the above text so that in cells B1 & B2 I only have the 4 digit text in the second bracker i.e. in B1 = D1111 but B2 will only be 1804 (note A2 does not have two set of open and close brackets).

I other words I just want , starting from right to count the 6 dighits and get rid of the two brackets i.e. right(a1,6) or right(a2,6) but somehow i dont wnat to include the ( and )

Is this possible?

Any help is apprecaite it.

Thanks in Advance

[Glenn Kennedy]

Hi there. Try this out:

=MID(RIGHT(A1,6),2,4)

[rv02]

This works perfectly. Thank you for your help