extracting infomation from parenthesis when there are 2 sets within a string....?

[Kim31669]

I need to extract only the data within the last set of parenthsis. Here is my text.

Customer (Central) (SS01) I used this formula::: =MID(A7,FIND("(",A7&"(")+1,SUM(FIND({"(",")"},A7&"(0)")*{-1,1})-1) and I returned the first text string. "central" Please advise on how to modify it to return only the text from the last set of (). length of information in the last set of () varies from 1 to 4 characters.</SPAN>

<TBODY>
</TBODY><COLGROUP><COL></COLGROUP>

 

[ITWare2008]

Hi Kim,

Try this

=MID(A7,SEARCH("(",A7,SEARCH("(",A7)+1)+1,(LEN(A7)-SEARCH("(",A7,SEARCH("(",A7)+1))-1)

Hope this help

Vândalo

P.S. - By the way - welcome to the board

 

[BobUmlas]

=left(mid(a7,find(char(4),substitute(a7,"(",char(4),len(a7)-len(substitute(a7,"(",""))))+1,100),find(")",mid(a7,find(char(4),substitute(a7,"(",char(4),len(a7)-len(substitute(a7,"(",""))))+1,100))-1)

 

[Kim31669]

Thank you!

I am now getting the information from the 2nd set of parenthesis, but I am also getting the last ")" as well.

"SS01)"

 

[Rick Rothstein]

I need to extract only the data within the last set of parenthsis. Here is my text.

Customer (Central) (SS01)

<tbody>
</tbody>

If your text could be longer than 100 characters, increase the 100's to be longer than the count and change the 200 to twice the number you settle on)...

=TRIM(LEFT(RIGHT(SUBSTITUTE(SUBSTITUTE(A1,"(",")"),")",REPT(" ",100)),200),100))

 

[István Hirsch]

This formula extracts the text after the second opening bracket:

=IFERROR(SUBSTITUTE(MID(A1,FIND("(",A1,FIND("(",A1)+1)+1,40),")",""),"")