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