Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Automatically Create HyperLink from Text

  1. #1
    Join Date
    6th October 2004
    Posts
    33

    Automatically Create HyperLink from Text

    I've got some data coming into a cell from a database that is a hyperlink. Except excel is displaying the hyperlink as text and I would have to go through and manually update each cell to make it a hyperlink.

    Is there a way to make these cells automatically become hyperlinks?

    one approach I thought of was importing the hyperlink as text into say cell A1 and then displaying the same text as a clickable hyperlink in cell B1... I'm not sure how to do that though. Or perhaps there is a better approach?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    14th July 2004
    Posts
    10,539

    Re: Automatically Create HyperLink from Text

    Take a look at the HYPERLINK worksheet function.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    6th October 2004
    Posts
    33

    Re: Automatically Create HyperLink from Text

    easy enough. Thanks for the help...

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

  1. velu130468

Possible Answers

  1. Automatically Open Hyperlink Picture In Report
    By 01silverado in forum Excel and/or Access Help
    Replies: 1
    Last Post: July 14th, 2007, 01:29
  2. Create Hyperlink
    By boredatworkguy in forum EXCEL HELP
    Replies: 2
    Last Post: February 27th, 2007, 07:03
  3. Create Hyperlink
    By JuZeLLa in forum EXCEL HELP
    Replies: 1
    Last Post: February 23rd, 2007, 12:39
  4. Automatically redirect hyperlink when cell value changes
    By HarryFrohlich in forum EXCEL HELP
    Replies: 10
    Last Post: May 15th, 2006, 15:29
  5. Create a Hyperlink in VBA
    By GJM in forum EXCEL HELP
    Replies: 3
    Last Post: April 10th, 2006, 15:33

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
  •  
porno