Using the format painter icon copied that "Blank" value to other cells for
you????

Attellati wrote:

Don't criticize me for this extremely simple solution but everyone should
know this but I'll gonna tell ya just for thrill of it ... select a blank
cell, type blank in it, now choose format wizard e.g. the magic paint brush
icon and click a cell and drag til your hearts content and click on the magic
paint brush icon and there you go, all the cells you have selected should
have the word 'blank' filled in. It's the simplist way of doing it, you don't
need any defty IT skills and even your good-old grandma can do it.

Cheers,

--
Attellati

"Dave Peterson" wrote:

I don't use xl2007 enough to know where those menu items are hidden.

Instead of using edit|goto, use F5 (or ctrl-g).

But the rest should be the same.

Jason Hall wrote:

Dave, you will have to dumb this down for me a little bit. I am not use to
macros and I am running Excel 2007

"Dave Peterson" wrote:

Record a macro
Select the range to fix (include the non-blank cells, too)
edit|goto special|blanks
type BLANK
hit ctrl-enter to fill all the selected cells (just the empty cells in the
original range)
Stop recording the macro.

Personally, I'd do something like this manually until it was part of a larger
mechanized routine.



Jason Hall wrote:

I have a large spreadsheet that I would like to fill all blank or rather
empty cells with a text value of "BLANK" Can this be done with an If
statement or Macro? If so, what would it be?

Jason

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson