The below VBA code also can help you to solve this task, please do as this:ġ. To double click the cell to activate the hyperlinks one by one will waste lots of time, here, I can introduce some formulas for you, please do as follows:Įnter this formula: =HYPERLINK(A2, A2) into a blank cell where you want to output the result, and then drag the fill handle down to apply this formula to the cells that you want, and all text URLs have been converted to active hyperlinks, see screenshot: If you have a list of URL addresses which are plain text, how could you activate theses text URLs to the clickable hyperlinks as following screenshot shown?Ĭonvert a bunch of text URLs to active hyperlinks with formulasĬonvert a bunch of text URLs to active hyperlinks with VBA codeĬonvert a bunch of text URLs to active hyperlinks Kutools for Excel How to convert a bunch of text URLs to active hyperlinks in Excel?
0 Comments
Leave a Reply. |