| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
