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

Hi,
In VBA

Sub Test()
Range("B1") = Range("A1") & " " & Range("B1")
End Sub

The bit in the middle puts a space between.

regards,
Don

"hyyfte" wrote in message
...

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


--
hyyfte
------------------------------------------------------------------------
hyyfte's Profile:
http://www.excelforum.com/member.php...o&userid=13187
View this thread: http://www.excelforum.com/showthread...hreadid=261648