Filling empty cells with a value

Hi

Is there a way of finding empty or blank cells and filling them with XXX or
some text so I can find and replace XXX with YYY?

Thanks
Ian

You could try

Edit>Goto>Special>Blanks

Then type XXX and hit Ctrl-Enter not just Enter.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Ian Richardson ACITP" <IanRichardsonACITP@discussions.microsoft.com> wrote
in message news:D2D4F0C7-AB5C-44E1-8AD8-273C257D57B6@microsoft.com...
> Hi
>
> Is there a way of finding empty or blank cells and filling them with XXX
or
> some text so I can find and replace XXX with YYY?
>
> Thanks
> Ian

Try something like this:

Select the range you want impacted

<edit><replace>
Find what: (leave this blank)
Replace with: XXX
Click the [Replace All] button

That should put "XXX" in each blank cell in the highlighted region.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Ian Richardson ACITP" wrote:

> Hi
>
> Is there a way of finding empty or blank cells and filling them with XXX or
> some text so I can find and replace XXX with YYY?
>
> Thanks
> Ian

You can apply an autofilter and select Blanks from the pull-down menu.
In the first blank cell enter XXX then copy this down while the filter
is still active.

If you have blanks in many different columns, then select the topmost
cell within the data area and Edit | GoTo and select Special followed
by Current Region. Then Edit | GoTo | Special again and this time
select Blanks. You can then type XXX and use CTRL-Enter to copy it into
each blank cell.

Hope this helps.

Pete

Thanks for the quick replies.

The find and replace does what I want. Easy if you think about it!

Ian

"Pete_UK" wrote:

> You can apply an autofilter and select Blanks from the pull-down menu.
> In the first blank cell enter XXX then copy this down while the filter
> is still active.
>
> If you have blanks in many different columns, then select the topmost
> cell within the data area and Edit | GoTo and select Special followed
> by Current Region. Then Edit | GoTo | Special again and this time
> select Blanks. You can then type XXX and use CTRL-Enter to copy it into
> each blank cell.
>
> Hope this helps.
>
> Pete
>
>