I’m sorry I seem to have forgotten to do the following.

Merge into cell A1 the text content of C1,D1,E1, and F1.

Thanks for the help

--
sungen9
-----------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914
View this thread: http://www.excelforum.com/showthread.php?threadid=55381