|
|
#1
12-02-2020, 12:00 AM
|
|||
|
|||
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. 
|
|
#3
12-02-2020, 01:15 AM
|
|||
|
|||
|
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.
|
|
|
|
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 |
Windows 10 
Office 2010 32bit
Linear Mode
