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