Operation method
First, open the excel table that we want to process, and select the cell that we want to convert to a URL link.
Then find the formula at the top of the table and click to enter.
Find the search and reference icon in the formula and click the small arrow below.
In the drop-down function list, we select the function shown in the following figure.
On the function parameter page that opens, we click the first small arrow on the right.
Then we use the mouse to select the cell where we want to convert the URL to clickable links.
After selecting, we click the Restore button on the right side of the interface.
After the function parameter interface is restored, we click the OK button below.
Then you can see in the selected cell that the URL links in text format have been converted into blue clickable URL links.