Ignore blanks formula

[Surreyview]

Hello,
Please may someone help me.
I have a number of tabs in my spreadsheet, some have datapopulated, others don’t.
I have an overview tab that brings everything together.
I am simply using the formula: =tab!cell
However this is bring in a ‘0’ when there is no data (thecell is blank), does anyone what formula I would use to copy the data acrossfrom the cell but ignore it if its blank?

I have tried a number of formulas but not had a lot of luckof getting the right one.

Thank you!

 

[Special-K99]

IF(TAB!Cell="","",TAB!Cell)

 

[AlanY]

try

=if(isblank(tab!cell),"",tab!cell)