You can put this in a helper column and copy down

=IF(ISTEXT(A1),A1,"")

Vaya con Dios,
Chuck, CABGx3



"simonsmith" wrote:


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