In N7:

=IF(D5="","",D5)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Shannan" wrote in message
...
Hi,
I want to make cell N7 show the text that is written in cell D5, but if
there isn't anything written in D5 yet, then i want N7 to remain blank.
What
formula can i use?