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
|