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