Extract numbers from cell with Text and Numbers

[wiredwrx]

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

 

[Peo Sjoblom]

A 3 step solution,

1. select the column, do data>text to columns, select delimited, click next,
check commas as delimiter and other and in other put a left parenthesis,
click finish.

2. Select the new range and do ctrl + H, in the find what put a right
parenthesis, leave replace with blank and click replace all.

3. While range is still selected press F5, click special, check constants
but uncheck everything but numbers, click OK, press Ctrl + C, go to a new
page and do edit>paste special and select transpose

Do your averaging


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[wiredwrx]

Thanks for the help and the quick response. I will try that.

Michael

 

[Peo Sjoblom]

If you do this on a regular basis and this solution works for you then you
can record a macro while doing it the next time, put it in the personal
macro workbook and run the macro


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com