I have a column of URLs that are not click-able. Is there some way to batch enable them so I don't have to go to each one?
I think this is the solution: http://apple.stackexchange.com/questions/120960/numbers-v3-1-automatically-link- urls-in-spreadsheet.
One way is to use the HYPERLINK() function, like this:
SG
Hi 4thSpace,
Adding to SG's reply, the HYPERLINK function allows you to include link-text in the display.
From the Function Browser:
The HYPERLINK function creates a clickable link that opens a webpage or new email message.
HYPERLINK(url, link-text)
▪ url: A standard universal resource locator. url is a string value that must contain a properly formatted universal resource locator string.
▪ link-text: An optional string value that specifies the text that appears as a clickable link in the cell. If link-text is omitted, url is used as link-text.
Formula in C2 (and Fill Down)
=HYPERLINK(A2,B2)
Regards,
Ian.
How to change URLs into links?
