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

S

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
 
B

broro183

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top