What is in column 2. Is that to be concatenated also? Do you want th
data in column one replaced with the concatenated data?

JAV

--
JAV
-----------------------------------------------------------------------
JAVB's Profile: http://www.excelforum.com/member.php...fo&userid=2930
View this thread: http://www.excelforum.com/showthread.php?threadid=49935