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