Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Excell - Convert web names to links.  (Read 3279 times)

0 Members and 1 Guest are viewing this topic.

Geek-9pm

    Topic Starter

    Mastermind
  • Geek After Dark
  • Thanked: 1026
    • Gekk9pm bnlog
  • Certifications: List
  • Computer: Specs
  • Experience: Expert
  • OS: Windows 10
Excell - Convert web names to links.
« on: September 28, 2017, 11:01:45 PM »
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.  :)



Salmon Trout

  • Guest
Re: Excell - Convert web names to links.
« Reply #1 on: September 29, 2017, 08:34:22 AM »
..........

DaveLembke



    Sage
  • Thanked: 662
  • Certifications: List
  • Computer: Specs
  • Experience: Expert
  • OS: Windows 10
Re: Excell - Convert web names to links.
« Reply #2 on: September 29, 2017, 12:53:46 PM »
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>


strollin



    Adviser
  • Thanked: 84
    • Yes
  • Certifications: List
  • Computer: Specs
  • Experience: Guru
  • OS: Windows 10
Re: Excell - Convert web names to links.
« Reply #3 on: September 29, 2017, 01:16:51 PM »
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 afterwards

Geek-9pm

    Topic Starter

    Mastermind
  • Geek After Dark
  • Thanked: 1026
    • Gekk9pm bnlog
  • Certifications: List
  • Computer: Specs
  • Experience: Expert
  • OS: Windows 10
Re: Excell - Convert web names to links.
« Reply #4 on: September 29, 2017, 02:41:13 PM »
Thanks to all.
I like the answer strollin gave.  :)

Salmon Trout

  • Guest
Re: Excell - Convert web names to links.
« Reply #5 on: September 29, 2017, 04:16:10 PM »
Thanks to all.
I like the answer strollin gave.  :)
Do you end up with clickable links in the exported HTML?