How to paste text into a comment box using toolbar commands

  • Thread starter Thread starter Halifax
  • Start date Start date
H

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 .....
 
Halifax said:
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 .....
Click to expand...


I don't see the problem. Copy the text, and in the new worksheet paste into
a comment...
 
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
 
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.
 
Back
Top