Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
I have a Numbers (4.3.1) spreadsheet where one column is a list of URLs. I'd like to change them all to links that will open that page in a browser, but need a way to do it for the entire column instead of one by one. Any ideas?
Thanks!
Hi Andertoons,
The HYPERLINK function is your friend
Formula in C2 (and Fill Down)
=HYPERLINK(A2,B2)
That combines the URL in A2 with your required display in B2 into a clickable link in C2.
Select column C, Copy, and Menu > Edit > Paste Values to "fix" the results. Then you can delete columns A and B.
More information:
Type = in any table cell to bring up the Function Browser.
Type hyperlink in the search box to see an explanation:
Also, take a look at Numbers > Preferences > Auto-Correction > Automatically detect links
(but I am not sure if that works retrospectively).
Regards,
Ian.
Hi Andertoons,
The HYPERLINK function is your friend
Formula in C2 (and Fill Down)
=HYPERLINK(A2,B2)
That combines the URL in A2 with your required display in B2 into a clickable link in C2.
Select column C, Copy, and Menu > Edit > Paste Values to "fix" the results. Then you can delete columns A and B.
More information:
Type = in any table cell to bring up the Function Browser.
Type hyperlink in the search box to see an explanation:
Also, take a look at Numbers > Preferences > Auto-Correction > Automatically detect links
(but I am not sure if that works retrospectively).
Regards,
Ian.
Perfect! Thanks so much!!!
Change text in multiple cells to web links
