+ Reply to Thread
Results 1 to 7 of 7

Hyperlink

  1. 03-29-2022, 05:28 PM #1
    Roy Shimp
    Roy Shimp is offline
    Registered User
    Join Date
    03-29-2022
    Location
    Jacksonville, Fla
    MS-Off Ver
    windows 365
    Posts
    4

    Hyperlink

    Hi - I'm trying to change the column of names i imported so they can be "clickable" and go the the appropriate website.
    Thank you

    MICHAEL ADAMS CONSTRUCTION INC.com
    NOONEY CONSTRUCTION INC.com
    ALESCH & SONS, INC..com
    HOME RIGHT INC.com
    ALLEN BUILDERS INC.com
    MILLENNIUM CONTRACTING & DEVELOPMENT INC.com
    OCEAN BOULEVARD CONSTRUCTION INC.com
    ONE ELEVEN CONSTRUCTION, LLC.com
    ORION DESIGN + BUILD INC..com
    JDA BUILDERS, LLC.com
    ANDERSON BUILDING RESOURCES LLC.com
    U B EXTERIOR DESIGN INC.com
    F B ANDREWS CONTRACTING LLC.com
    CAPA DEVELOPERS INC.com
    RONALD P ARDARY CONSTRUCTION INC.com
    ARMOUR CONSTRUCTION, LLC.com
    ARMSTRONG CONSTRUCTION.com
    ED ARNOLD CONSTRUCTION LLC.com
    DAVID ARVIN CONTRACTING, LLC.com
    ASHCRAFT MARINE CONSTRUCTION INC.com
    PAUL ASHLEY CONSTRUCTION LLC.com
    BRAASH INC.com
    ENGINEER SERVICE CORPORATION.com
    Reply With QuoteRegister To Reply
  2. 03-29-2022, 06:45 PM #2
    janmorris
    janmorris is offline
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,141

    Re: Hyperlink

    domain names don't have spaces, commas, ampersand, plus symbols etc, or double dot com (..com) so there is no way to make those into valid links.
    As a gesture off appreciation, you can click * Add Reputation at the foot of any of the posts of members who helped you reach a solution.

    And finally, was your problem solved? if so, please click Thread Tools above the first post of your enquiry, then select [Solved]
    Reply With QuoteRegister To Reply
  3. 03-30-2022, 08:00 AM #3
    Roy Shimp
    Roy Shimp is offline
    Registered User
    Join Date
    03-29-2022
    Location
    Jacksonville, Fla
    MS-Off Ver
    windows 365
    Posts
    4

    Re: Hyperlink

    thank you for the reply.
    How would i make them valid links?
    Reply With QuoteRegister To Reply
  4. 03-30-2022, 08:05 AM #4
    janmorris
    janmorris is offline
    Valued Forum Contributor janmorris's Avatar
    Join Date
    07-24-2021
    Location
    Japan
    MS-Off Ver
    Google Sheets (& Mac 2021)
    Posts
    1,141

    Re: Hyperlink

    You will need the URL.

    A quick search of google will give steps for the basic procedure. 👍🏼😎
    Reply With QuoteRegister To Reply
  5. 03-30-2022, 08:21 AM #5
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,673

    Re: Hyperlink

    How would i make them valid links?
    Hopefully a bit more detailed than the previous reply!

    You would need to have the URLs in your Excel file. You cannot change what you have into valid links: Excel has no way of knowing what the corresponding URL would be for each company.

    The short answer remains that you cannot get Excel to turn those company names into URLs. Sorry!
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  6. 03-30-2022, 08:47 AM #6
    Roy Shimp
    Roy Shimp is offline
    Registered User
    Join Date
    03-29-2022
    Location
    Jacksonville, Fla
    MS-Off Ver
    windows 365
    Posts
    4

    Re: Hyperlink

    thank you, i'll look into it.
    Reply With QuoteRegister To Reply
  7. 03-30-2022, 08:48 AM #7
    Roy Shimp
    Roy Shimp is offline
    Registered User
    Join Date
    03-29-2022
    Location
    Jacksonville, Fla
    MS-Off Ver
    windows 365
    Posts
    4

    Re: Hyperlink

    thank you, i'll look into more deeply.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA loop through column and extract embedded hyperlink and create clickable hyperlink
    By Jay S. in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-26-2021, 04:42 PM
  2. userfom load value txtbox hyperlink to cell and create short hyperlink
    By remco77a in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2020, 08:38 AM
  3. [SOLVED] What is the hyperlink formula to create a hyperlink in Excel to a bookmark in Word
    By BryanHCR in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-23-2019, 11:41 PM
  4. [SOLVED] With Hyperlink formula & vba, I want to copy text of hyperlink to the cell it's linked to
    By Freakytone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2017, 05:46 PM
  5. [SOLVED] Excel 2010 Create a macro to check if cell contains hyperlink then apply hyperlink style
    By chasidar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2013, 04:48 AM
  6. [SOLVED] How to open the Hyperlink formula's sheet and hide all sheets except clicking Hyperlink
    By PRADEEPB270 in forum Excel General
    Replies: 1
    Last Post: 02-23-2013, 05:18 AM
  7. Re: Moving rows with Hyperlink doesn't move hyperlink address
    By Jim in forum Excel General
    Replies: 5
    Last Post: 06-22-2006, 07:10 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1