Extracting numbers

  • Thread starter Thread starter James Silverton
  • Start date Start date
J

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
 
Depending on the regularity or pattern in thee imported text, you might be
able to use Text to Columns.

- Jon
 
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
 
Back
Top