How to paste text into a comment box using toolbar commands

[Halifax]

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 .....

 

[Gordon]

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 .....

I don't see the problem. Copy the text, and in the new worksheet paste into
a comment...

 

[Gary''s Student]

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

 

[Bernard Liengme]

Why use two cells? Paste Special back into B1
best wishes

 

[Shane Devenshire]

Hi,

I see your problem, you want to copy all the data with one command.

Here's a strange trick:
1. Highlight the range and choose copy
2. Open Word and choose Paste.
3. Select the Word data and choose copy
4. Move into the comment on the other Excel spreadsheet and choose Paste.