software

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
456Will someone be able to help please?--
KH_GS
------------------------------------------------------------------------
KH_GS's Profile: www.excelforum.com/member.php...oamp;userid=32920
View this thread: www.excelforum.com/showthread...hreadid=538784Hi,

Maybe not the most elegant way to do it but i think it works.
If you put this formula in cell b1 and copy down the lenght of your
data:

=IF(MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1amp;{0, 1,2,3,4,5,6,7,8,9})),1024)=quot;quot;,quot;quot;,A1)

Regards,
Bondi=IF(ISNUMBER(A1),A1,quot;quot;)

and fill it down!
Regards,
Stefi

?H_GS??ezt ?rta:

gt;
gt; Data:
gt; _Column_A_
gt; H111
gt; B222
gt; Abc
gt; 1XE3
gt; 2XD4
gt; 22GT
gt; 12SD
gt; Apple
gt; Orange
gt; 123
gt; 456
gt;
gt; I need to copy cells that contains number onto a new column.
gt;
gt; Output:
gt; _Column_B_
gt; H111
gt; B222
gt; *blank*
gt; 1XE3
gt; 2XD4
gt; 22GT
gt; 12SD
gt; *blank*
gt; *blank
gt; 123
gt; 456
gt;
gt;
gt; Will someone be able to help please?
gt;
gt;
gt; --
gt; KH_GS
gt; ------------------------------------------------------------------------
gt; KH_GS's Profile: www.excelforum.com/member.php...oamp;userid=32920
gt; View this thread: www.excelforum.com/showthread...hreadid=538784
gt;
gt;


No this does not work because it does not catch contents with a mixture
of text and numbers.
Stefi Wrote:
gt; =IF(ISNUMBER(A1),A1,quot;quot;)
gt;
gt; and fill it down!
gt; Regards,
gt; Stefi
gt;
gt; ?H_GS??ezt ?rta:
gt;
gt; gt;
gt; gt; Data:
gt; gt; _Column_A_
gt; gt; H111
gt; gt; B222
gt; gt; Abc
gt; gt; 1XE3
gt; gt; 2XD4
gt; gt; 22GT
gt; gt; 12SD
gt; gt; Apple
gt; gt; Orange
gt; gt; 123
gt; gt; 456
gt; gt;
gt; gt; I need to copy cells that contains number onto a new column.
gt; gt;
gt; gt; Output:
gt; gt; _Column_B_
gt; gt; H111
gt; gt; B222
gt; gt; *blank*
gt; gt; 1XE3
gt; gt; 2XD4
gt; gt; 22GT
gt; gt; 12SD
gt; gt; *blank*
gt; gt; *blank
gt; gt; 123
gt; gt; 456
gt; gt;
gt; gt;
gt; gt; Will someone be able to help please?
gt; gt;
gt; gt;
gt; gt; --
gt; gt; KH_GS
gt; gt;
gt; ------------------------------------------------------------------------
gt; gt; KH_GS's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32920
gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=538784
gt; gt;
gt; gt;--
KH_GS
------------------------------------------------------------------------
KH_GS's Profile: www.excelforum.com/member.php...oamp;userid=32920
View this thread: www.excelforum.com/showthread...hreadid=538784