Replacing only the empty cells.

C

Colin Hayes

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
 
L

Luke M

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.
 
G

Gord Dibben

Code and/or formulas not necessary.

Select column P.

F5>Special>Blanks>OK

In active blank cell enter A-Z and hit CTRL + ENTER


Gord Dibben MS Excel MVP
 
C

Colin Hayes

Hi

OK thanks for your solution.

This works fine , and I'm grateful for your help.



Best Wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top