paste link 0

[Ellen]

I have designed a tracking sheet in which the information
is paste linked to several other sheets. If there is no
information to paste link, a "0" appears. Is there a way
to remove this "0"? It could be confusing for those using
this Excel file.

Thanks in advance,
Ellen

 

[J.E. McGimpsey]

One way:

=IF(Sheet1!A1="", "", Sheet1!A1)

 

[Ellen]

Thank you so much! It works perfectly!

-----Original Message-----
One way:

=IF(Sheet1!A1="", "", Sheet1!A1)


.