I have a column of twitter Hyperlinks, is it possible to (as in html) turn them into text that are links so that each hyperlink is instead the word Twitter
https://twitter.com/abc becomes the link Twitter
Thanks
I have a column of twitter Hyperlinks, is it possible to (as in html) turn them into text that are links so that each hyperlink is instead the word Twitter
https://twitter.com/abc becomes the link Twitter
Thanks
Adjust your column as necessary. It will skip over any cell that doesn't have a hyperlink already in it.
Please Login or Register to view this content.
I'm interested in starting a career working with VBA, if anyone knows of any opportunities!
Yes.... assuming Cell A1 has your url:
I see Walrus already answered in a much tidier way... My assumption was that the cell had a url but not necessarily a link alreadyPlease Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
I only assumed because that's what the example showed. It would be pretty easy to modify your approach with a For loop if not. Will see what OP says.My assumption was that the cell had a url but not necessarily a link already
Indeed walruseggman, but I like your approach. Mine of course was just how to set the link and text, not a proper full solution, since some looping and checking needs to take place.
I went with walruseggman solutions as it was ready made, thank you both, much appriciated
Glad to help. Please mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks