MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Replacing Blank Cells with Data


Posted by Alan on September 20, 2001 3:53 AM

A manager I work with would like to replace all of the blank cells in a given range with the "-" character, or other data.

Is there an easy way to replace all blanks cells with data in a specified range.


Posted by Eric on September 20, 2001 4:57 AM

=if(isblank(cell address),"-",cell address)

Then copy back to the original column and paste as values.

Posted by Juan Pablo on September 20, 2001 6:16 AM

Try this one... select the range that includes the Blank cells. Now select Edit - Go To - Special - Blanks cells - OK.

Now type "-" or whatever text you want, and hit Control - Enter, that way you'll get all the blanks to be replaced with the "-"

Juan Pablo

Posted by Eric on September 20, 2001 6:58 AM

Much better solution- thanks! (NT)