|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 22nd, 2009, 01:59 AM
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
May 22nd, 2009, 02:13 AM
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
May 22nd, 2009, 02:38 AM
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
May 22nd, 2009, 02:55 AM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
