=IF(ISNUMBER(A1),A1,"")

and fill it down!
Regards,
Stefi

€žKH_GS€� ezt Ã*rta:


Data:
_Column_A_
H111
B222
Abc
1XE3
2XD4
22GT
12SD
Apple
Orange
123
456

I need to copy cells that contains number onto a new column.

Output:
_Column_B_
H111
B222
*blank*
1XE3
2XD4
22GT
12SD
*blank*
*blank
123
456


Will someone be able to help please?


--
KH_GS
------------------------------------------------------------------------
KH_GS's Profile: http://www.excelforum.com/member.php...o&userid=32920
View this thread: http://www.excelforum.com/showthread...hreadid=538784