how to copy blank cells

's Computer Specifications

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

's Computer Specifications

=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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copy an intial cells contents into the next series of blank cells ina column	freeriderxlt	Microsoft Excel Discussion	2	25th Aug 2009 07:47 AM
Copy to first Blank cell in Colum C Non blank cells still exist be	=?Utf-8?B?VWxyaWsgbG92ZXMgaG9yc2Vz?=	Microsoft Excel Programming	2	8th Oct 2006 07:35 PM
copy text of cells down to blank cells	=?Utf-8?B?YW5kcmVzZzE5NzU=?=	Microsoft Excel Programming	3	5th Oct 2006 07:14 PM
copy blank cells	=?Utf-8?B?VmljbmVzd2FyaSBNdXJ1Z2Fu?=	Microsoft Excel Misc	1	1st Dec 2004 02:12 PM
copy blank cells	=?Utf-8?B?VmljbmVzd2FyaSBNdXJ1Z2Fu?=	Microsoft Excel Misc	0	1st Dec 2004 03:33 AM