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.