Why use two cells? Paste Special back into B1
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gary''s Student" wrote in message
...
The trick is to use the formula bar

Say we have text in A1 thru A5

1. in B1 enter:
=A1&A2&A3&A4&A5

2. copy B1 and paste/special/values in B2
B2 contains the concatenated text

3. click on B2 and hi-light the text in the formula bar
then touch CNTRL-c

4. on the new worksheet, insert a comment and touch CNTRL-v
--
Gary''s Student - gsnu200827


"Halifax" wrote:

I have a range of cells containing text on one worksheet.
I want to paste this text into a Comment Box in a NEW worksheet.
Thanks for your help .....