Hello All,

I hope someone can help.

I have a column of cells. Each cell contains some text, and then a
number in parenthases, then a comma, and then come text, and then a
number in parenthases, This repeats probably as many as 5 times,
though some cells have fewer then 5. I want to somehow, if possible,
extract JUST THE NUMBERS. If I can automatically get a total so that I
can average the total (dividing by a number in another column, but in
the same row as the numbers extracted) that would be great. I am most
concerned with not having to manually enter the numbers again.

If anyone has any suggestions, I would appreciate your help
tremendously.

Michael


--
wiredwrx
------------------------------------------------------------------------
wiredwrx's Profile: http://www.excelforum.com/member.php...o&userid=21145
View this thread: http://www.excelforum.com/showthread...hreadid=533935