how to copy blank cells
 

Hi all
I am trying to copy contents of cells from one worksheet to another but i
would like blank cells to remain blank. Presently i am using the formula =a1
for instance and if there is nothing in that cell it puts a 0 there. what
formula should I use to end up with something in the destination cell only if
there is something in the original cell?

Thanks

how to copy blank cells
 

=IF(A1="","",A1)
--
Gary''s Student - gsnu200739


"Careeranalysts" wrote:

Hi all
I am trying to copy contents of cells from one worksheet to another but i
would like blank cells to remain blank. Presently i am using the formula =a1
for instance and if there is nothing in that cell it puts a 0 there. what
formula should I use to end up with something in the destination cell only if
there is something in the original cell?

Thanks

how to copy blank cells
 

Thanks very much - that's great.
Leo

"Gary''s Student" wrote:

=IF(A1="","",A1)
--
Gary''s Student - gsnu200739


"Careeranalysts" wrote:

Hi all
I am trying to copy contents of cells from one worksheet to another but i
would like blank cells to remain blank. Presently i am using the formula =a1
for instance and if there is nothing in that cell it puts a 0 there. what
formula should I use to end up with something in the destination cell only if
there is something in the original cell?

Thanks