Thanks for your help, but I need something a bit different. I need t
add to the text in cell B1 NOT concatenate into cell c1. Is there an
way to do that? More specifically. I have a table with a notes colum
in workbook A and a table with a notes column in workbook B. I need t
combine the notes column in workbook B so it contains BOTH the note
from B and the notes from A. Thanks

--
hyyft
-----------------------------------------------------------------------
hyyfte's Profile: http://www.excelforum.com/member.php...fo&userid=1318
View this thread: http://www.excelforum.com/showthread.php?threadid=26164