Hi

Select the range of cells. Hit F5 and select Blanks from the Special page.
Then type - and hit Ctrl+Enter.

Hope this helps.
Andy.

"Colin Hayes" wrote in message
...

Hi

In column A , I have some cells which contain text , and others which are
blank.

Is there a formula which will fill the empty ones with a dash (-) , whilst
leaving the full ones intact?

Hope you can help.



Best Wishes


Colin