Checking if a cell is filled up with data

[xpucto]

Hi!

I would like to write a function that checks if a cell is empty or if it has any kind of data. The kind of datas (numbers or words or bocth) is irrelevant. The only thing that is important is whether or not the cell is empty. Has anyone an idea how I could write such a function?

Thanks

[mangesh_yadav]

=IF(A1="","",A1)

Enter this formula in cell B1. If A1 is empty, then B1 will be empty, else it will put the value of A1 in B1

Mangesh