how to copy blank cells

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add cells between blank cells 3
copy data from one worksheet and disregard blank cells 6
Leaving a formula cell blank when data has not yet been added. 5
How To Have A Cell Be Blank If... 2
Need macro to move to first blank cell in column 6
select all non-blank cells 3
Excel formula, sum the value cell and if empty cell left blank 0
Ignore Blanks 2

Top