Multiple data forms in a column

R

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?
 
B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM Char 9
Count entries in the column translating to minutes. 5
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Pivot Table - Counting Unique Values within one column of da 1
Lookup changing data range in external workbook 5
custom data validation on cells with data validation values 2
With F1 value, look at A, if match or partial match return B 5
Unhide column difficulty 3

Top