Finding Numbers with Cells that also contain letters
Hi All,
I have a column of data, the cells are filled with numbers and comments of
text, they do not consistantly follow suit i.e the numbers are at the
beginning of the cell necessarily.
I want to be able to find where the numbers are and extract them into
another field.
Does anyone know of a formula that can do this?
--
Adam
-----------
Windows 98 + Office Pro 97
|