#1
|
|||
|
|||
CSV - Hyperlink - creating
Hello, I need to find a way to create a hyperlink in a cell that already contains a URL. I can go to the Fx box on top showing the URL, click it and hit enter. This will create the link in the cell. BUT, I have thousands and it would take too much time.
Maybe a macro would work. I tried recording one and was not able to. I am able to click the F2 key and then the Enter key and a hyperlink is created. Would live to have a macro for this so I can use it for many rows at a time. Is there a faster way? Please email me at poker@tampabay.rr.com with you advice. Many thanks in advance. |
#2
|
|||
|
|||
Doesnt =HYPERLINK(K2,K2) work?
|
#3
|
|||
|
|||
A couple on minutes with Google, and here you go!
How do I convert a column of text URLs into active hyperlinks in Excel? - Stack Overflow Before searching with google, I tried exactly what is recommended there as first <=HYPERLINK(...)>, and it worked. |
#4
|
|||
|
|||
Thanks for the info.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating A Keyboard Shortcut In Place of Using Mouse To Select Hyperlink Object | PowerPointerNeedsHelp | PowerPoint | 3 | 07-06-2017 01:47 AM |
Help creating a hyperlink drop down list between documents | SconnieGuy91 | Word | 3 | 11-30-2016 05:26 PM |
Creating a hyperlink from Control Content Using CRM Word Templates | RFielding@ipmglobal.net | Mail Merge | 2 | 06-12-2016 04:06 PM |
Creating internal hyperlink that highlights specific text within a word doc | WR748 | Word | 1 | 03-16-2015 05:22 AM |
Creating A Hyperlink | Techknology | Outlook | 0 | 11-30-2006 01:16 PM |