Excel 2007 : Formula for extraction of text in bracket

Hi, I'm trying to get a formula to extract some text from a cell. The cells have different length, but the info that I wanted is surrounded with a bracket. Please refer to the attachment. Appreciate if someone can provide me the formula to do so. Thanks a lot in advance.

Hi Bernard,

For question 1, try:

=MID(A5,FIND("(",A5)+1,LEN(A5)-FIND("(",A5)-2)

For question 2 first result, try:

=MID(E5,FIND("(",E5)+1,FIND(")",E5)-FIND("(",E5)-1)

For question 2 second result, try:

=MID(E5,FIND("^",SUBSTITUTE(E5,"(","^",2))+1,FIND("^",SUBSTITUTE(E5,")","^",2))-FIND("^",SUBSTITUTE(E5,"(","^",2))-1)

The last formula assumes you won't have a ^ symbol in your text. If so, pick another symbol to use.

An Option:

Ben, if you check your last formula (the second result for question 2) you'll see that it only works in the sample data because the values between the first set of parenthesis is always 4 characters long. If you change it to any other length it fails to return the correct string.

It pretty much returns a string length from the last set of parenthesis equivalent to the length of the string in the first set.