I have a column of links copied from the web, links are copied with the names of the original links. They have URLs inside. How I can remove names, and get the column of URL addresses?

CodePudding user response：

I think the question is really not "how remove title text from link", but "how to extract plain text URLs from rich text links."

You can do that with the RichTextLinks custom function. Install the function in Extensions > Apps Script, and then put a formula like =RichTextLinks("A2:A") in row 2 of a free column.