Multiple data forms in a column

[Red]

This is going to sound silly, but I'm hitting a wall with this seemingly
simple formula.

I have a column of data, lets say its all in column A. In that column there
are a number of different values that could be present, both alpha (by
itself) and numeric (by itself). In column B I want to write a formula that
looks at column A and if the value there is a number, then carry that value
into column B. however if the value in column A is alpha characters, I want
the cell in Column B to remain blank.

Any suggestions?

 

[Bernard Liengme]

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

 

[Red]

Thanks.... now I feel stupid.

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

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

 

[Bernard Liengme]

No need to fell that, we all have a day when the brain takes a vacation!
Sometimes I have two in a row.