Displaying numbers contained in ()

[bsmith]

I am having trouble with finding the correct formula to display a numbe
that is contained in (). An example of the number that I am workin
with is 123(456) and I need the result to = 456. I am trying to onl
display the info that is in (). The problem that I have ran into i
the info inside and within the () changes hourly and obtained through
web based query and may be 123(456) or 789(1). There is no consistan
pattern to the numbers. Is there a way or formula to only display th
info within the ()

 

[Frank Kabel]

Hi
try:
=--MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)+1)

 

[bsmith]

Thank you. I was not familiar with the MID function. Greatl
appreciated

 

[icestationzbra]

frank,

what does the '--' at the beginning do? i have heard of concepts calle
unary and double unary, is that what it is? if you could explain what i
their functionality, i will be thankful.

thanks,

mac

 

[icestationzbra]

frank,

what does the '--' at the beginning do? i have heard of concepts calle
unary and double unary, is that what it is? if you could explain what i
their functionality, i will be thankful.

thanks,

mac

 

[bsmith]

I doubt that you will ever have a use for this formula but in order to
get everything to work correctly to convert 1234(876) to display only
876 this is the ending formula that I used:
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-2-FIND("(",A1)+1)

Once again, thanks for the help.

 

[Frank Kabel]

Hi
see:
http://www.mcgimpsey.com/excel/formulae/doubleneg.html

in this case the double minus is used to convert the Text value to a
real number

 

[Frank Kabel]

Hi
see your other post

 

[icestationzbra]

frank,

thanks for the info on double-negs.

the double post was due to internet connection problem.

thanks,

mac.