hi

=if(sheet1!A1="","",Sheet1!A1)

Regards
FSt1

"grahame" wrote:

i have created a work book and using the =sheet command can copy text from
one cell on a worksheet to another cell on another work sheet, but if i do
not add any text in the first worksheet a 0 appears in the cell on the second
worksheet, is there anyway to stop this by maybe adding additional values the
formula to stop it