=concatenate(C1,D1,E1,F1)

Need space?

=CONCATENATE(C1," ",D1," ",E1," ",F1)

HT

--
Bearacad

-----------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...fo&userid=3501
View this thread: http://www.excelforum.com/showthread.php?threadid=55381