excel
 

i am working on excell i wanted to copy text from one cell on worksheet 1 to
another cell in worksheet 2, this works using =sheet command, but if there is
no text in the cell on worksheet 1 it shows a 0 on worksheet 2 cell, it there
a way so it will not show 0

excel
 

Maybe

=IF(Sheet2!A1<"",Sheet2!A1,"")

Mike

"grahame" wrote:

i am working on excell i wanted to copy text from one cell on worksheet 1 to
another cell in worksheet 2, this works using =sheet command, but if there is
no text in the cell on worksheet 1 it shows a 0 on worksheet 2 cell, it there
a way so it will not show 0

excel
 

=if(a1="","",Sheet1!a1)

Regards,
Fred

"grahame" wrote in message
...
i am working on excell i wanted to copy text from one cell on worksheet 1
to
another cell in worksheet 2, this works using =sheet command, but if there
is
no text in the cell on worksheet 1 it shows a 0 on worksheet 2 cell, it
there
a way so it will not show 0