Extracting numbers
 

I recently had to extract the numerical data from the text for
the cells in a fairly long column. I know there are available
user functions based on a loop and ISNUMBER but has anyone got a
favorite method using built-in worksheet or formatting
functions? Since my problem was something I don't expect to have
to do frequently, I simply copied the column to Word and used
its wild-cards in Replace instead of Excel's pitifully small
list.


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

Extracting numbers
 

Depending on the regularity or pattern in thee imported text, you might be
able to use Text to Columns.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"James Silverton" wrote in message
...
I recently had to extract the numerical data from the text for the cells in
a fairly long column. I know there are available user functions based on a
loop and ISNUMBER but has anyone got a favorite method using built-in
worksheet or formatting functions? Since my problem was something I don't
expect to have to do frequently, I simply copied the column to Word and
used its wild-cards in Replace instead of Excel's pitifully small list.


James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

Extracting numbers
 

Hello, Jon!
You wrote on Sun, 10 Sep 2006 21:24:07 -0400:


I did the sensible thing and posted also to m.p.excel.misc and
got some good suggestions. One of the problems was that the
spacing and position of the numbers was not fixed.

Thanks again!

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not