Duplicate data in a cell...
 

I have made a form in Excel. When you enter a name into the "Name" cell it
automatically copies that name to another cell under "Signature" (done by
simply using "other cell"="first cell"). The problem is that if the cell
used to store the Name is blank then the other "Signature" cell shows "0".

Is there a way to get rid of the "0" when the cells are blank?

=IF(A1="","",A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"The Outlaw Dozy Wales" <The Outlaw Dozy
wrote in message ...
I have made a form in Excel. When you enter a name into the "Name" cell
it
automatically copies that name to another cell under "Signature" (done by
simply using "other cell"="first cell"). The problem is that if the cell
used to store the Name is blank then the other "Signature" cell shows "0".

Is there a way to get rid of the "0" when the cells are blank?

Thanks Bob! Worked like a charm.

Tom



"Bob Phillips" wrote:

=IF(A1="","",A1)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"The Outlaw Dozy Wales" <The Outlaw Dozy
wrote in message ...
I have made a form in Excel. When you enter a name into the "Name" cell
it
automatically copies that name to another cell under "Signature" (done by
simply using "other cell"="first cell"). The problem is that if the cell
used to store the Name is blank then the other "Signature" cell shows "0".

Is there a way to get rid of the "0" when the cells are blank?