=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