| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging multiple columns of data into one column of data | Excel Discussion (Misc queries) | |||
| Multiple forms | Excel Discussion (Misc queries) | |||
| stacking multiple column data into a single column | Excel Worksheet Functions | |||
| Compile/Analyze Word Form Field data from multiple forms? | Excel Discussion (Misc queries) | |||
| Column charts with multiple data in each column | Charts and Charting in Excel | |||
Linear Mode
