Thread: Copy from Sheet 2, but remain blank if no data

Hello, I have two spreadsheets, sheet 1 and sheet 2. Sheet 2 has the data. Sheet 1 copies the data from Sheet 2 like this:-
='Sheet 2'!A1
If Sheet 2 cell A1 has data, its a straight forward copy, if theres no data, i get a 0. Im wanting the cell to be blank if there's no data to copy accross.

After this step im doing a straight forward copy all and paste all into Access. Im trying to avoid finding all the 0's and deleting them.

Thank you.

=IF('Sheet 2'!A1="","",'Sheet 2'!A1)

or

='Sheet 2'!A1&""

but, with the second option, amy numeric data would be converted to text.


Regards