I have a Google Sheet with Text in A1:

Welcome to my Website!

Visit some Amazon Products: https://amzn.to/3o7UGKS

King regards!

So what I'm looking for is how to get the link Amazon Link from the text in cell A1 in B1? B1 should be:


  • Welcome to Web Applications. Please show what you tried and add a brief description of your search/research efforts as is suggested in How to Ask. – Rubén Jan 13 at 17:14

You can try this:


This formula assumes that your line breaks are caused by ASCII character 10.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.