|
Answer» I have a spreadsheet withal the cells in one column are web sites
Example:
Code: [Select]http://abc.net
http://bbc.com
http://yahoo.com
http://usa.gov
They are strings, but are not yet links. I want them to be links before I export the sheet as a HTML document. If it was just the four above, I would do it by hand. But there are more. So how do I tell the program to convert the entire column into links?
Thank you.
..........In perl I have created prepended and appended to create URL lists for farming information online, it COULD be used to make a webpage with all links on it:
You could prepend and append such as:
Code: [Select]first prepend write to file <a href="
then write to file http://abc.net
then append ">
then write to file http://abc.net
then append </a>
to create
Code: [Select]<a href="http://abc.net">http://abc.net</a>
<a href="http://bbc.com">http://bbc.com</a>
<a href="http://yahoo.com">http://yahoo.com</a>
<a href="http://usa.gov">http://usa.gov</a>
Do you just want a single webpage with them all listed so that you scroll down through?
Thinking prepend this...
Code: [Select]<HTML>
<BODY>
<CENTER>
Then run through all to place within body tag as explained above...
Then append closing tags
Code: [Select]</BODY>
</HTML>
Create a 2nd column with the FORMULA =HYPERLINK(A1) (Assuming your first link is in cell A1)
Copy that formula to all the rows you wish to convert
If you don't wish to have 2 columns, delete the original afterwardsThanks to all.
I like the answer strollin gave. Quote from: Geek-9pm on September 29, 2017, 02:41:13 PM Thanks to all.
I like the answer strollin gave.
Do you end up with clickable links in the exported HTML?
|
