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