Extracting numbers

[James Silverton]

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

 

[Jon Peltier]

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

- Jon

 

[James Silverton]

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