Numbers: how to get URL from cell containing a link?

Question

Level 1

34 points

Numbers: how to get URL from cell containing a link?

This question was asked by TimCoin several years ago and SGIII gave a great answer here: Numbers: how to get URL from cell contain… - Apple Community.

However the solution no longer seems to be working with Mac OS 12.6 ☹️

I'm restarting the now stale question:

Cell A contains text with a link (Example text), now I would like to have the cell next to it with only the link (specifically just after/including HTTP*). What formula do I need for this?

For example:

Cell A contains: Example text

Then only collect the URL: Apple in Cell B.

Posted on Sep 25, 2022 2:04 PM

Reply

Answer 1

Best reply

SGIII

Level 8

35,306 points

Sep 26, 2022 8:51 AM in response to hab1

Here's the Shortcut pictured above (click the link in Safari and you can inspect the Shortcut and install it if you want).

https://www.icloud.com/shortcuts/31047a0c46bd 2041c0aed79e0ca8847d6e

And here are the results I got:

My steps:

Select cells with links in column A
Command-c to copy to clipboard
Run the Shortcut.
Click cell B2.
Command-v to paste.

I have Smart Web and Email Links turned off (unchecked) at Edit > Substitutions in the menu.

SG

Reply

Answer 2

SGIII

Level 8

35,306 points

Sep 26, 2022 7:28 AM in response to hab1

Life has gotten easier with the advent of Shortcuts!

Fire up the Shortcuts app and drag in actions like this:

Just select the cell(s), command-c to copy to clipboard, then run the Shortcut. Then select a destination cell and command-v to paste.

Note that this Shortcut retrieves the entire URL not just the domain name.

If you want to extract just the domain name (it's a little unclear from your post) then you could easily a Numbers formula to extract it, or build that functionality into the Shortcut. Post if you need that.

SG

Reply