Is there an easier way to write a formula that does the same other than:

=IF(D1<"",D1, IF(D2<"",D2, IF(D3<"",D3, Etc,""))))

so that Excel will display the contents of anything displayed in Column D?
Generally, there should only be one entry in Column D.

Thanks