Clasina_Field is seeking help to copy text with a link from Discourse to Google Sheets in one action. IAmGav and pfaffman provide workarounds involving multiple steps, such as copying the username and adding a hyperlink, or using a formula to create a hyperlink. However, Clasina_Field finds these solutions too onerous for novice volunteers and may opt for collecting links only. pfaffman suggests using the data explorer login to obtain the desired data, and shares a link to Google Sheets shortcuts (https://support.google.com/docs/answer/181110) that may be helpful.
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.)
There would be two parts to your query.
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.
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
Maybe you can get the data you want with the data explorer login?
I don’t know if this will help, but it might: Keyboard shortcuts for Google Sheets - Computer - Google Docs Editors Help