Hi
see:
http://www.dicks-blog.com/archives/2...t-1/trackback/

--
Regards
Frank Kabel
Frankfurt, Germany

Adam wrote:
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?