Extract numbers from cell with Text and Numbers
 

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

Extract numbers from cell with Text and Numbers
 

A 3 step solution,

1. select the column, do datatext 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 editpaste special and select transpose

Do your averaging


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"wiredwrx" wrote in
message ...

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

Extract numbers from cell with Text and Numbers
 

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

Michael


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

Extract numbers from cell with Text and Numbers
 

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


"wiredwrx" wrote in
message ...

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

Michael


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