| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Replacing only the empty cells.
Hi In column P I have cells which are blank , and cells which have word content. I need to replace all the blank cells with the words 'A-Z' , and leave those cells already with content as they are. Can someone help with some code , please? Grateful for any assistance. Best Wishes Colin |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing only the empty cells.
Insert a column after P. In new column, row 2:
=IF(ISBLANK(P2),"A-Z",P2) and copy formula down. Then copy entire section, and do a paste special - values onto column P to create static values. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Colin Hayes" wrote: Hi In column P I have cells which are blank , and cells which have word content. I need to replace all the blank cells with the words 'A-Z' , and leave those cells already with content as they are. Can someone help with some code , please? Grateful for any assistance. Best Wishes Colin |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing only the empty cells.
Code and/or formulas not necessary.
Select column P. F5SpecialBlanksOK In active blank cell enter A-Z and hit CTRL + ENTER Gord Dibben MS Excel MVP On Wed, 17 Jun 2009 14:21:52 +0100, Colin Hayes wrote: Hi In column P I have cells which are blank , and cells which have word content. I need to replace all the blank cells with the words 'A-Z' , and leave those cells already with content as they are. Can someone help with some code , please? Grateful for any assistance. Best Wishes Colin |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Replacing only the empty cells.
Hi OK thanks for your solution. This works fine , and I'm grateful for your help. Best Wishes In article , Gord Dibben <gorddibbATshawDOTca@?.? writes Code and/or formulas not necessary. Select column P. F5SpecialBlanksOK In active blank cell enter A-Z and hit CTRL + ENTER Gord Dibben MS Excel MVP On Wed, 17 Jun 2009 14:21:52 +0100, Colin Hayes wrote: Hi In column P I have cells which are blank , and cells which have word content. I need to replace all the blank cells with the words 'A-Z' , and leave those cells already with content as they are. Can someone help with some code , please? Grateful for any assistance. Best Wishes Colin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing 0 value with empty | Excel Discussion (Misc queries) | |||
| Replacing an empty cell | Excel Discussion (Misc queries) | |||
| Replacing empty cells with '-' | Excel Worksheet Functions | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
Linear Mode
