![]() you could spend all day looking, but sometimes it's just easier to do it and be done with it.)ġ) Copy and paste just the cells containing the hyperlinks to a new spreadsheet.Ģ) Export the spreadsheet, click "Change File Type," select "Save As Another File Type" and save it as a web page (aka an HTML file).ģ) Open the web page in your browser and view the source.Ĥ) Copy and paste the source into an text editor.ĥ) Using the Find/Replace function of the text editor, remove the leading and trailing text of each hyperlink. (I discovered this page when I had the same question myself an hour ago. This may sounds like a brute force method, but it's the best way I've come up with. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |