I’ve got a bunch of linked text in my Google Sheet that I copied from a website. The links work fine but they’re not showing up as hyperlink formulas. I want to get just the URLs from these links and put them in the column next to each one. Is there a way to do this without using formulas?
I tried looking for something like this:
=GETURL(A1)
But I can’t find anything that works for my situation. The links aren’t formulas so the usual tricks don’t help. I’d rather not use a script if I can avoid it but I’m open to any ideas. Has anyone figured out how to grab these hidden URLs from linked text in Sheets?
I encountered a similar challenge before and solved it with a simple clipboard trick. Rather than resorting to scripts or formulas, I copied the cells with the linked text and then used the paste special option to paste the links into another column. This method extracts the URL from the text without needing any formulas. I found it effective when the links weren’t formatted as formulas originally, and it saved me quite a bit of time. This approach should also work well for your situation.
hey, i had the same problem! wat worked for me was using the ‘paste special’ thing. just copy ur linked cells, then right-click where u want the URLs and pick ‘paste special’ > ‘paste link’. it pulls out just the URLs without any fancy stuff. super easy and quick!
I’ve dealt with this exact issue before, and I found a neat workaround that doesn’t involve formulas or scripts. What worked for me was using the ‘Paste special’ feature in Google Sheets. Here’s what I did:
- Select the cells with the linked text
- Copy them (Ctrl+C or right-click > Copy)
- Right-click on the destination cell where you want the URLs
- Choose ‘Paste special’ > ‘Paste link’
This method extracts just the underlying URLs from the linked text. It’s quick, doesn’t require any external tools, and preserves your original data. I’ve used this technique multiple times when dealing with data copied from websites, and it’s always worked like a charm.
Just remember, this approach pastes the URLs as plain text, not as clickable links. But from what you described, that seems to be exactly what you’re looking for. Hope this helps!