Thread: Inserting text from a cell in another tab
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
  
Posts: 1,998
Default Inserting text from a cell in another tab
=IF(B!A1="","",B!A1)

Vaya con Dios,
Chuck, CABGx3



"Karen Smith" wrote:

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?
Reply With QuoteReply With Quote