In my macro enabled 365 workbook, in column G, I have a range of cells (G2 - G10) that contain formula to create text stings in those cells based on values elsehere in the workbook. I want my coworkers to be able to copy the text from these cells and then paste that string into a clinical application (a bit like pasting into Word). I dont want to show the text to be copied in the cell as it is quite long and looks messy in the workbook, but instead show an icon to indicate that there is text to copy. Is that possible?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Show an Icon in a cell, attach text so that it can be copied and pasted
- Thread starter Spoursy
- Start date
Excel Facts
Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Similar threads
- Question
- Replies
- 9
- Views
- 410
- Question
- Replies
- 0
- Views
- 803
- Replies
- 8
- Views
- 622
- Question
- Replies
- 2
- Views
- 352
- Replies
- 2
- Views
- 383
