Assuming column D is free, in D1 put

=IF(OR(B1="",C1=""),D2,D2&" "&A1)

and copy this down the data.

The answer as you specified will be in cell D1, copy this and Paste
special = values to your new location.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=375874