Hi,
I have a long column of data, some cells have numbers in the cells some
with text.
I want to get the numbers out. Any ideas on a formula for this?

Thanks

Simon


--
simonsmith
------------------------------------------------------------------------
simonsmith's Profile: http://www.excelforum.com/member.php...o&userid=34235
View this thread: http://www.excelforum.com/showthread...hreadid=570070