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
|