Thank you for the video. Do you know how to extract the hyperlink in excel to show the name of the link. I have a list of urls, but want the name of the link - i.e. - ruclips.net/video/ZpVU-S0pado/видео.html to show Josh Gallagher - Look At Me Now (Official Music Video) - RUclips
Thanks for the question. If you right click and go to Hyperlink (or click Link), you can change the Display Text to be the more user friendly description. Hope that helps!
@@MyExcelOnline - thanks but, I meant doing the reserve of " Extract Data from a Website Link in Microsoft Excel" - to change a list of URLs to the name of the actual link.
Thanks for clarifying. I think you would have to use VBA to do that. Are you familiar with VBA? If so, try something like this (you may have to modify it a little): Sub ReplaceHyperlinks() Dim ws As Worksheet Dim xHyperlink As Hyperlink Set ws = Application.ActiveSheet For Each xHyperlink In ws.Hyperlinks xHyperlink.TextToDisplay = Replace(xHyperlink.TextToDisplay, "http*", "what you want your display text to be") Next End Sub
It's really valuable lessons to us.. Thank you so much
You are very welcome! Thanks for watching!
Great job.
Thanks!
Thank you for the video. Do you know how to extract the hyperlink in excel to show the name of the link. I have a list of urls, but want the name of the link - i.e. - ruclips.net/video/ZpVU-S0pado/видео.html to show Josh Gallagher - Look At Me Now (Official Music Video) - RUclips
Thanks for the question. If you right click and go to Hyperlink (or click Link), you can change the Display Text to be the more user friendly description. Hope that helps!
@@MyExcelOnline - thanks but, I meant doing the reserve of " Extract Data from a Website Link in Microsoft Excel" - to change a list of URLs to the name of the actual link.
Thanks for clarifying. I think you would have to use VBA to do that. Are you familiar with VBA? If so, try something like this (you may have to modify it a little):
Sub ReplaceHyperlinks()
Dim ws As Worksheet
Dim xHyperlink As Hyperlink
Set ws = Application.ActiveSheet
For Each xHyperlink In ws.Hyperlinks
xHyperlink.TextToDisplay = Replace(xHyperlink.TextToDisplay, "http*", "what you want your display text to be")
Next
End Sub
@@MyExcelOnline Thanks so much for the information. I am going to give it a try.
OK, great! Please let us know if you have any further questions.