=IF('name and number of cell'="","",'name and number of cell')
or you can format not show zeros
as an example
General;-General;
will not show zeros
Regards,
Peo Sjoblom
"Micha" wrote:
Hello,
I've got a problem with copying things.
If I copy something in exel by using: ='name and number of cell'
And the cell where I copy from doesn't have any information,
ther automaticly appears an 0(zero) in the cell where I am copying to.
How can I get rid of that zero?
Thanks
|