I have a couple of Excel spreadsheets which have colums of internet links as text (with and without the http in front)
www.example.com
www.anotherexample.com
thirdexample.com/index.html
http://www.example4.com
etc.
It would be enormously convienent for me if these links were the clickable kind I could open directly from Excel, but I only know how to change them one at a time. (For example, right click, hyperlink, past cell contents into the address box, click ok.)
Is there a way to make all the links clickable in a column at once? I feel like I should be able to write a macro for this, but, but I'm not sure what I'd put in it.
Edit: Never mind, found the information I needed here
www.example.com
www.anotherexample.com
thirdexample.com/index.html
http://www.example4.com
etc.
It would be enormously convienent for me if these links were the clickable kind I could open directly from Excel, but I only know how to change them one at a time. (For example, right click, hyperlink, past cell contents into the address box, click ok.)
Is there a way to make all the links clickable in a column at once? I feel like I should be able to write a macro for this, but, but I'm not sure what I'd put in it.
Edit: Never mind, found the information I needed here
Facebook
Twitter