How to separate hyperlinks from the link location in Excel

Q I have copied some information from web pages and pasted it into an Excel worksheet.

I have a column that contains hyperlinks and I would now like to use functions to separate the visible name of the hyperlink from the link location.

Mayo Marriott

A Let’s say a downloaded link to Google is in cell A2.

To display what Microsoft calls the friendly name in the HYPERLINK function, which you described better as the visible name, enter in another cell

=PROPER(MID(TEXT(B13,”Text”),12,6))

This is because the name Google is 12 characters in and 6 characters long.

The word Text is the second argument of the TEXT function and establishes the initial formatting. PROPER capitalises the G. To display the link location use

=T(A2)