Formula - Help !!!

[ITCOM]

i want write a Formula only capture aaaa information in test field xxxx
(aaaa)

Thanks

 

[Toppers]

Please don't start a new thread for the same question (which has already been
answered).

 

[bj]

If test field is A1
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)