=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


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=374119