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

Similar Threads

Transfer data between two tables 3
return blank cell if condition met 2
VBA: Programmatically clear a one-key shortcut bound to a document 2
Dynamic pointing to a cell 0
IF - AND - OR statement? 4
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
cell lookup 2
Change different cell based on conditional statement 4

Top