1

I have a cells that have multi-line of text including multiple hrefs that I'd like to turn into clickable links. I can "format" the cell by clicking on the text of the href and clicking on another cell. How do I do this in a scalable way for all cells?

https://google.com
https://yahoo.com
text line
another text line

I want to turn google and yahoo into clickable links.

I've tried to replace https:// with =HYPERLINK(" and .com with ") but gave me formula error.

I've tried these suggestions but they didn't work: How to convert non-clickable links into clickable in Google Sheets?

New contributor
Steve is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
  • Sorry, you cannot. Just manually. Or you would need to split the cells. – marikamitsos May 23 at 16:39

Your Answer

Steve is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.