| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transfer a name from one cell to another but leave clear if clear?
Hi,
I am trying to find the formula that allows me to copy a name from one cell to another, but if the original cell is empty then the corresponding cell is also empty. A6 B9 John Smith John Smith formula: =A6 But when A6 is empty I get a zero in B9. I have tried this =IF(A6="",""),A6 but it comes up with a ##### error message. Can anyone help Cheers Scott |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Transfer a name from one cell to another but leave clear if clear?
=IF(A6="","",A6)
If this post helps click Yes --------------- Jacob Skaria "Scoober" wrote: Hi, I am trying to find the formula that allows me to copy a name from one cell to another, but if the original cell is empty then the corresponding cell is also empty. A6 B9 John Smith John Smith formula: =A6 But when A6 is empty I get a zero in B9. I have tried this =IF(A6="",""),A6 but it comes up with a ##### error message. Can anyone help Cheers Scott |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Transfer a name from one cell to another but leave clear if clear?
hi, The display of repeated hash symbols in a cell often means that the column is not wide enough. Try changing the column width or Format - Cells & tick Wrap Text. hth Rob -- broro183 Rob Brockett. Always learning & the best way to learn is to experience... ------------------------------------------------------------------------ broro183's Profile: http://www.thecodecage.com/forumz/member.php?userid=333 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=99314 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Transfer a name from one cell to another but leave clear if clear?
Try this:
=REPT(A6,1) "Scoober" wrote: Hi, I am trying to find the formula that allows me to copy a name from one cell to another, but if the original cell is empty then the corresponding cell is also empty. A6 B9 John Smith John Smith formula: =A6 But when A6 is empty I get a zero in B9. I have tried this =IF(A6="",""),A6 but it comes up with a ##### error message. Can anyone help Cheers Scott |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I clear a cell | Excel Worksheet Functions | |||
| clear the clear the web page email attachment lines | Excel Discussion (Misc queries) | |||
| Clear contents but leave formulas in Excel | New Users to Excel | |||
| Clear cell when value is 0 | New Users to Excel | |||
| How do I clear a worksheet of values, but leave formulas intact? | Excel Worksheet Functions | |||
Linear Mode
