Detecting Numbers in a cell

[KH_GS]

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?

[Bondi]

Hi,

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},A1&{0,1,2,3,4,5,6,7,8,9})),1024)="","",A1)

Regards,
Bondi

[Stefi]

=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
>
>

[KH_GS]

No this does not work because it does not catch contents with a mixture of text and numbers.

=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
>
>