How to get text which is inside the brackets in excel sheet
=MID(A1,FIND("(",A1)+1,LEN(A1)-FIND("(",A1)-1) if it always ends with the
closing parenthesis, or
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
--
David Biddulph
"arun" wrote in message
...
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
|