if Numeric then copy cell

[martinez_pedro]

Hi everyone does anyone has a macro that can copy a cell if the first part of the cell is numeric
So lets say
Sample 1
cell A1 = 1234 Cats this will be true so then copy cell to b1
Sample 2
cell A1 = cats 1234 this will be false simply don't copy
so regardless of what the cell contains as long as the cell starts with a number that will be true
Thanks for your help

 

[Dryver14]

none macro way is in cell B1

=IF(ISNUMBER(LEFT(A1,1)+0),A1,"")

 

[martinez_pedro]

Thank you very much the formula works good

 

[Dryver14]

Thanks for responding, you are welcome