On 10 Aug, 14:15, Tim879 wrote:
You could also use the isblank function

=if(isblank(a1),"",a1)

On Aug 10, 6:10 am, Bookworm wrote:

I am linking some Text cells in a worksheet to other cells to
automaticaly link them with Copy/Paste Link.

Even though the source cell is formatted as text the target cell shows
a zero (0) when empty. How do I get the target cell to stay blank?

Sorry I am getting mixed up with another posting I have on pasting
cells to the next blank space on another worksheet.

Profuse apolgies.