ExcelBanter - How to get text which is inside the brackets in excel sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to get text which is inside the brackets in excel sheet (https://www.excelbanter.com/excel-worksheet-functions/228646-how-get-text-inside-brackets-excel-sheet.html)

Arun

How to get text which is inside the brackets in excel sheet

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

Jacob Skaria

How to get text which is inside the brackets in excel sheet

=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

David Biddulph[_2_]

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

All times are GMT +1. The time now is 11:36 AM.