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

A

arun

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
 
D

David Biddulph

=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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to flag the items that net off each other 3
Bring data from header fields to the columns 3
Bring fields from header to columns 3
open text file, get file from directory, update file 2
Is it possible to get data from several word files having static format to one excel worksheet. 2
Splitting the characters in the cell 4
remove brackets 4
}}}} Squiggly Brackets spanning 2 or more lines 1

Top