Detecting Numbers in a cell

  • Thread starter Thread starter KH_GS
  • Start date Start date
K

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
 
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
 
=IF(ISNUMBER(A1),A1,"")

and fill it down!
Regards,
Stefi

„KH_GS†ezt írta:
 
No this does not work because it does not catch contents with a mixture
of text and numbers.
 
Back
Top