=SUBSTITUTE(MID(A1,SEARCH("(",A1,1)+1,100),")","")
--
If this post helps click Yes
---------------
Jacob Skaria


"arun" wrote:

Hi all,

I am having field values like below,

xyz(xxx)
abc(rrrr)
pqr(as)

my need is to get string which is inside the bracket.
xxx
rrrr
as

How can i get this values, plz help me on this regard