Hi,

You can use this formula to extract the numeric portion on the string (along
with the sign)

=1*MID(B9,MIN(SEARCH({"-";0;1;2;3;4;5;6;7;8;9},B9&"-0123456789",1)),SEARCH(")",B9,1)-MIN(SEARCH({"-";0;1;2;3;4;5;6;7;8;9},B9&"-0123456789",1)))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"ryguy7272" wrote in message
...
I posted this onto the end of a post that I put up earlier today. This is
tough and I can't tell if people stopped reading the old post or if no one
has been able to come up with a solution.

Basically, this is the scenario:
New request; just a bit different. I have this kind of setup in several
cells:
="(-30.5)"

This will eliminate the left parentheses:
=SUBSTITUTE(AD8,CHAR(40),"")

This gets rid of the right:
=SUBSTITUTE(AD8,CHAR(41),"")

Also, I have to get rid of the quotes!! Four characters need to be
stripped, and I want to calculate an average on top of that!! I know it's
a
tall order. Can it be done?

I tried this, committed with CSE:
=AVERAGE(--SUBSTITUTE(AD8:AD12,CHAR(40),""))--SUBSTITUTE(AD8:AD12,CHAR(41),"")

That didn't work, but even if it did, I would still need to strip out the
quotes somehow. Any ideas on this?

Thanks,
Ryan---



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.