Try something like...

=IF(Sheet2!A1<"",Sheet2!A1,"")

Hope this helps!

In article ,
"Lucylambkin" wrote:

I want to insert a formula/function that inserts data from another
spreadsheet, but that if the cells in the other spreadsheet are blank they
are left blank.

I have tried setting up a formula, but if the cell in the other spreadsheet
is blank, then the spreadsheet which has the formula shows a 0 in the cell.

Can anyone help