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