| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How to paste text into a comment box using toolbar commands
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 ..... |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to paste text into a comment box using toolbar commands
"Halifax" wrote in message
... 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... -- Asking a question? Please tell us the version of the application you are asking about, your OS, Service Pack level and the FULL contents of any error message(s) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to paste text into a comment box using toolbar commands
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 ..... |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to paste text into a comment box using toolbar commands
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 ..... |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How to paste text into a comment box using toolbar commands
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. -- If this helps, please click the Yes button Cheers, Shane Devenshire "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 ..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| description of toolbar commands | Excel Discussion (Misc queries) | |||
| Creating Custom Commands on a Toolbar | Excel Worksheet Functions | |||
| how do I paste excel text into a comment box? | Excel Discussion (Misc queries) | |||
| Excel toolbar commands | Excel Worksheet Functions | |||
| Toolbar commands | Excel Discussion (Misc queries) | |||
Linear Mode
