Transfer a name from one cell to another but leave clear if clear?

[Scoober]

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

 

[Jacob Skaria]

=IF(A6="","",A6)

If this post helps click Yes

 

[Teethless mama]

Try this:

=REPT(A6,1)