Copy from one cell to another.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FinlandGuy - 05 Dec 2007 13:11 GMT

I feel stupid asking this but there is a point. How can I type content
in one cell and it comes up in another cell without the 0 showing up.
e.g If I type something in A1 to be copyed to C3 I would type in C3
"=A1" right... But then this 0 pops up. I just want it blank in the
box unless I type something in A1.

Thanks in advance.

BR,
John

Reply to this Message

Don Guillett - 05 Dec 2007 13:22 GMT

Maybe you should. <G>
=IF(N1="","",N1)

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>I feel stupid asking this but there is a point. How can I type content
> in one cell and it comes up in another cell without the 0 showing up.
[quoted text clipped - 6 lines]
> BR,
> John

Reply to this Message

FinlandGuy - 05 Dec 2007 13:47 GMT

Thanks, Yes I got that, but what about if it in not a number but a
name? It pops up with this #VALUE! with numbers it works fine but not
if its a name

Reply to this Message

Roger Govier - 05 Dec 2007 14:34 GMT

Hi

It shouldn't make any difference.
What was suggested was saying if there is nothing in the source cell, don't
copy anything to the destination, otherwise copy the contents of the source
cell.
It has nothing to do with what the content of the source cell is, either
Text or Numeric..

You must have some other problem.
Post exactly what is in each of the cells that work, and those that don't
work, and what formula you are using for each.

Signature

Regards
Roger Govier

> Thanks, Yes I got that, but what about if it in not a number but a
> name? It pops up with this #VALUE! with numbers it works fine but not
> if its a name

Reply to this Message