| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
=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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Another question on how to find duplicate data | Excel Worksheet Functions | |||
| sending data from one cell to another (not using copy & paste) | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
| Retrieve last cell with data | Excel Worksheet Functions | |||
Linear Mode
