Thread: [Solved] CSV - Hyperlink - creating
View Single Post
 
Old 12-02-2020, 12:00 AM
pokerguy pokerguy is offline Windows 10 Office 2010 32bit
Novice
 
Join Date: Mar 2018
Posts: 3
pokerguy is on a distinguished road
Default 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.
Reply With Quote