Displaying numbers contained in ()

B

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 ()
 
I

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
 
I

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
 
B

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.
 
I

icestationzbra

frank,

thanks for the info on double-negs.

the double post was due to internet connection problem.

thanks,

mac.
 
Top