Комментарии:
Very Very Helpful, Thank you !!
ОтветитьThank you so much - now I can die in peace 🙏😉
Ответитьi am subscribe your channel. kindly create more videos to help us. thanks
Ответитьthank you so much sir. it is very useful for me. i am very much tired to find it but nothing any video to teach me. your video is very useful and i done my work just in the few second. ❣❣❣❣❣
ОтветитьSuper helpful. Thanks!
ОтветитьVery helpful thank you
ОтветитьYou are amazing! Thank you!
Ответитьthank you. this video made my day.
ОтветитьCan you do it in bulk ?
Ответитьsaved me hours
ОтветитьThank you Jeff! AMAZING... This save me so mucnh time w/ my work. Your instruction is easy to undersatnd and straightforward.
ОтветитьSuper
ОтветитьCan't thank you enough! 👍🖐
ОтветитьMy man, thank you !
ОтветитьThis was a huge time saver! Thank you so much!
ОтветитьThank you!
Ответитьi love you
ОтветитьExactly what I was looking for. Thank you.
Ответитьthis does not work in my case. it displays the same hyperlink we try to decode...
ОтветитьOmg thanks!
ОтветитьBRILLANT!!! you just saved me literally
hours doing this manually!!!
OMG a video that doesn't open with "funny" jokes, or long explanations that restate what the title of the video already explains the video is about, or doesn't have any long ass logo animations, and doesn't promise not to waste your time after first babbling for 45 seconds?! I'm literally just subbing in support of a creator who doesn't engage in any of that other nonsense, and I haven't seen the video yet! Thank you for GETTING TO THE POINT and respecting your viewers' time!!
ОтветитьThis is pretty much what I need, BUT, I want to go one step further and only extract only PART of the URL in to a column, namely some numbers that occur at the end. Is this possible, or will I have just have to extract the whole URL and delete the first part that I don't need?
ОтветитьThank you so much
ОтветитьExcellent stuff. Exactly what I needed! Thanks so much. I am now a subscriber 😊
ОтветитьBLESS YOU! WOW! Me, too, me, too, me too! Saved HOURS of work with 2 min super simple explanation! THANK YOU!
ОтветитьThank you very much! It was helpful!
ОтветитьAmazing, thanks :3
You explain really good
when you create an add-in for this function you can use it all the time without opening or saving it as a macro-enabled workbook
Ответитьthanks a lot!!
ОтветитьThanks Man, You saved my time
ОтветитьYou're my hero
ОтветитьReally helpful. Thanks so much!
ОтветитьStandard Hyperlinks work but Imported from a html table into excel, doesn't work.
ОтветитьGreat video!
Ответитьthis is fantastic, but how to do this when the link is an image link?
Ответитьto make this function more usable return SubAddress as well
Function URL(Hyperlink As Range)
URL = Hyperlink.Hyperlinks(1).Address & Hyperlink.Hyperlinks(1).SubAddress
End Function
Thank you very much, it save a lot of time for me. Subscribed
ОтветитьAwesome!!! thank you so much!!
ОтветитьThank you
ОтветитьThank u so much sir
It saved my lot of time
Thank youuuu! Such a big helppppp!
ОтветитьThis is incredibly useful, and appreciate the work that you have completed! Well done!
ОтветитьYou just saved me a ton of work, thanks!
ОтветитьWhen iterating through excel cells ,how to find cell value has hyperlink
ОтветитьHelped a lot!!!!!!!!
Ответить