If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|