Prevent cell formulas which evaluate to blank “” from displaying as 0 when copy/pasted

[Jim75204]

Hi Experts

i have several cell formulas which use if functions and return “”. The problem is, when I copy the data and paste as values into a new workbook, the blank cells appear as 0. Ideally, these would just appear blank/empty. Is there a way to prevent this?  

It it also occurs with cell references. For example:

sheet1 has name in column A, address line 1 in column B, address line 2 in column C

sheet 2 has cell references to display the data from sheet 1 in different columns

such as =Sheet1!A2, =Sheet1!B2, etc.

if address line 2 is blank, it will display 0 when copied into a new workbook.

is there a way around this? I don’t want to simply hide the zeros. I’d like blank cells to remain blank.

[#2]

@Jim75204 

Wrap your formula with IF, like this: 

=IF(Sheet1!A2="",

"",

Sheet1!A2)

[#3]

@Twifoo 

Thanks so much!

[#4]

You’re very much welcome!