Multiple data forms in a column
 

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?

Multiple data forms in a column
 

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

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

"Red" wrote in message
...
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?

Multiple data forms in a column
 

Thanks.... now I feel stupid.

"Bernard Liengme" wrote:

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

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

"Red" wrote in message
...
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?

Multiple data forms in a column
 

No need to fell that, we all have a day when the brain takes a vacation!
Sometimes I have two in a row.
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Red" wrote in message
...
Thanks.... now I feel stupid.

"Bernard Liengme" wrote:

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

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

"Red" wrote in message
...
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?