# Are you a hotshot with G-sheets AND Discourse?
**URL:** https://meta.discourse.org/t/are-you-a-hotshot-with-g-sheets-and-discourse/161069
**Category:** Support
**Created:** [August 16, 2020, 10:08pm UTC](https://meta.discourse.org/t/are-you-a-hotshot-with-g-sheets-and-discourse/161069 "2020-08-16T22:08:31Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Clasina\_Field](https://meta.discourse.org/u/Clasina_Field)
#### Post date: [August 16, 2020, 10:08pm UTC](https://meta.discourse.org/t/are-you-a-hotshot-with-g-sheets-and-discourse/161069/1 "2020-08-16T22:08:31Z")
YOU ARE??? Then maybe you can help me out here.
I’d like to move text with a link (in this case, Baglady5,) to a cell in Google spreadsheet.
Highlight - copy - paste (into google sheets cell) doesn’t work.
I’m not finding anything in google help or online that gives me a combination of keys to do this in one action.
Is this even possible? (If it is you will be my special hero of the day.)
---
### Author:  [@IAmGav](https://meta.discourse.org/u/IAmGav)
#### Post date: [August 16, 2020, 10:18pm UTC](https://meta.discourse.org/t/are-you-a-hotshot-with-g-sheets-and-discourse/161069/2 "2020-08-16T22:18:09Z")
There would be two parts to your query.
1. copy the Name as Text and then pasting it in Sheets.
2. right click on the Username and select the “Copy link Address”. once this is done, add a hyperlink to the text copied in step 1
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [August 16, 2020, 10:25pm UTC](https://meta.discourse.org/t/are-you-a-hotshot-with-g-sheets-and-discourse/161069/3 "2020-08-16T22:25:42Z")
Maybe just copy the username into one cell and in the adjoining cell do something like
```
=hyperlink(CONCATENATE("https://meta.discourse.org/u/",A2))
```
I’ve got a sheet with sites that I maintain that pulls their current Discourse version, compares it with the version running on meta, and marks red the ones that are older.
---
### Author:  [@Clasina\_Field](https://meta.discourse.org/u/Clasina_Field)
#### Post date: [August 17, 2020, 12:27am UTC](https://meta.discourse.org/t/are-you-a-hotshot-with-g-sheets-and-discourse/161069/4 "2020-08-17T00:27:40Z")
You’re my heroes of the day for replying at all! Thank you, guys.
Those are workarounds that I had thought of. (I’m pleased that there wasn’t something obvious that I wasn’t seeing.) I really needed a simple, quick one-step process for novice volunteers who need to compile a list on a daily basis. A two step job is going to be too onerous for first-timers.
I may just suggest they collect links only, that’s one step. Well, a step and a click.
Thank you again for the solutions: I don’t feel totally OTL now. (Out to Lunch, LOL)
C
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [August 17, 2020, 12:12pm UTC](https://meta.discourse.org/t/are-you-a-hotshot-with-g-sheets-and-discourse/161069/5 "2020-08-17T12:12:03Z")
Maybe you can get the data you want with the [data explorer](https://meta.discourse.org/t/32566?silent=true) login?
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [August 24, 2020, 2:26pm UTC](https://meta.discourse.org/t/are-you-a-hotshot-with-g-sheets-and-discourse/161069/6 "2020-08-24T14:26:57Z")
I don’t know if this will help, but it might: [Keyboard shortcuts for Google Sheets - Computer - Google Docs Editors Help](https://support.google.com/docs/answer/181110?p=spreadsheets_shortcuts&visit_id=637338759741471080-2319158978&rd=1)