Inserting text from a cell in another tab

K

Karen Smith

I'm trying to insert text from tab B cell A into tab A cell A, when I do this
and the cell is blank it shows a 0. What formula would I use to leave the
cell blank if the text is empty?
 
B

Bob Phillips

=IF(B1="","",B1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top