+ Reply to Thread
Results 1 to 2 of 2

How to the heck do I make URLs clickable?

  1. #1
    Registered User
    Join Date
    06-19-2015
    Location
    Houston, Texas
    MS-Off Ver
    365
    Posts
    1

    How to the heck do I make URLs clickable?

    I used office 365.

    I have a program that I use to search google. The output is on a .csv file. When I open the output the URLs are not clickable until I make a hard return at the end of the URL. That is a pain in the butt. I'd really like the output to be clickable, so I can go through, one after the other, and open the various pages.

    Now the program I use has been built for my business specifically, and can ask the programmer to add anything.

    Do any of you have quick and easy suggestions for making the output add clickable URLs?

    I was thinking about adding a field that would take the URL output and make it clickable by adding a "Click me!" to it. Except I have NO idea how to do this. Would one of you amazing people explain how I can do this?

    I really would appreciate any help. Thank you.


  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: How to the heck do I make URLs clickable?

    CSV files are not Excel files, they are TEXT files. When Excel opens a CSV the text is converted into separate cells for display, but it's TEXT. No URLs, just text that look like URLs.

    So, the simplest answer is to open the CSV, create your clickable hyperlinks one time the hard way, then save the workbook as an actual .xlsx file so your Excel formatting and hyperlinks are preserved. If you save to CSV, that's text again, everything "Excel-ish" goes away.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to make cell that contains a URL not clickable?
    By kenwood in forum Excel General
    Replies: 1
    Last Post: 03-14-2015, 03:07 PM
  2. How can I make clickable boxes for cells?
    By Advice Pro in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-26-2013, 01:06 AM
  3. Make fields clickable to sum up data
    By Pagelite in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2012, 01:43 PM
  4. How can I make a clickable button to do a Key Combo?
    By BGerman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-21-2006, 12:05 PM
  5. Make bars on a bar chart clickable?
    By Mark Stephens in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-19-2005, 08:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1