| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replace all empty or " by the content of the cell above it
Good morning,
I wish to replace all empty ot cells with " to the value of the cell above it. Thanks. cg |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replace all empty or " by the content of the cell above it
if column A has your data starting in cell A2
add a new column B then in cell B2 do this =IF(A2="",B1,A2) and extend the formula down column B now copy column B Select column A edit paste special values now delete the column B you no longer need -- Allllen "hccatmo" wrote: Good morning, I wish to replace all empty ot cells with " to the value of the cell above it. Thanks. cg |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replace all empty or " by the content of the cell above it
Thank Allllen.
I am looking for way to change all columns and all rows using R1C1 and relative addressing. cg "Allllen" wrote: if column A has your data starting in cell A2 add a new column B then in cell B2 do this =IF(A2="",B1,A2) and extend the formula down column B now copy column B Select column A edit paste special values now delete the column B you no longer need -- Allllen "hccatmo" wrote: Good morning, I wish to replace all empty ot cells with " to the value of the cell above it. Thanks. cg |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replace all empty or " by the content of the cell above it
For truly empty cells...........
Select all cells then F5SpecialBlanksOK In active cell type an = sign then point to cell above. Hit CTRL + ENTER Cells with "" returned via formula are not considered "empty". Gord Dibben MS Excel MVP On Thu, 9 Nov 2006 11:32:02 -0800, hccatmo wrote: Thank Allllen. I am looking for way to change all columns and all rows using R1C1 and relative addressing. cg "Allllen" wrote: if column A has your data starting in cell A2 add a new column B then in cell B2 do this =IF(A2="",B1,A2) and extend the formula down column B now copy column B Select column A edit paste special values now delete the column B you no longer need -- Allllen "hccatmo" wrote: Good morning, I wish to replace all empty ot cells with " to the value of the cell above it. Thanks. cg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting if cell content is a formula | Excel Worksheet Functions | |||
| How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| lookup cell content in multiple files | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
