View Single Post
  #1   Report Post  
Adam
 
Posts: n/a
Default 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