How To Extract URL From A Hyperlink In Excel - The Fastest Way Possible!

How To Extract URL From A Hyperlink In Excel - The Fastest Way Possible!

Excel University

2 года назад

69,229 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

prajkta survase
prajkta survase - 16.11.2023 14:31

Very Very Helpful, Thank you !!

Ответить
enter a name
enter a name - 20.10.2023 21:14

all heros dont wear capes!

Ответить
Marvin the Martian
Marvin the Martian - 10.10.2023 18:19

Thank you so much - now I can die in peace 🙏😉

Ответить
mahtab raza
mahtab raza - 02.10.2023 12:05

i am subscribe your channel. kindly create more videos to help us. thanks

Ответить
mahtab raza
mahtab raza - 02.10.2023 12:03

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. ❣❣❣❣❣

Ответить
Andres Aristizabal
Andres Aristizabal - 24.09.2023 01:48

Super helpful. Thanks!

Ответить
Nishma
Nishma - 07.09.2023 10:51

Very helpful thank you

Ответить
David K
David K - 01.09.2023 18:16

You are amazing! Thank you!

Ответить
Muhammad Waheed
Muhammad Waheed - 17.08.2023 10:01

thank you. this video made my day.

Ответить
justin scott
justin scott - 16.08.2023 20:52

Can you do it in bulk ?

Ответить
Saurabh Saksena
Saurabh Saksena - 08.08.2023 00:34

saved me hours

Ответить
geibet
geibet - 05.08.2023 10:16

Thank you Jeff! AMAZING... This save me so mucnh time w/ my work. Your instruction is easy to undersatnd and straightforward.

Ответить
Krish9811
Krish9811 - 27.07.2023 11:05

Super

Ответить
DefineME
DefineME - 26.07.2023 09:46

Can't thank you enough! 👍🖐

Ответить
Johan Daugaard Drejer
Johan Daugaard Drejer - 03.07.2023 09:36

My man, thank you !

Ответить
Jordan Laycock
Jordan Laycock - 26.06.2023 21:11

This was a huge time saver! Thank you so much!

Ответить
Paul H
Paul H - 20.06.2023 16:52

Thank you!

Ответить
Денис Маценко
Денис Маценко - 02.06.2023 09:21

i love you

Ответить
Mike Stengel
Mike Stengel - 31.05.2023 03:45

Exactly what I was looking for. Thank you.

Ответить
Le Brethon valorise son patrimoine naturel
Le Brethon valorise son patrimoine naturel - 27.05.2023 21:46

this does not work in my case. it displays the same hyperlink we try to decode...

Ответить
Cath Gommp
Cath Gommp - 24.05.2023 19:09

Omg thanks!

Ответить
Follow_Fraser
Follow_Fraser - 17.05.2023 00:59

BRILLANT!!! you just saved me literally
hours doing this manually!!!

Ответить
Zooming By
Zooming By - 05.05.2023 22:08

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!!

Ответить
Michael Stokes
Michael Stokes - 25.04.2023 14:13

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?

Ответить
Relaxing Beats
Relaxing Beats - 23.04.2023 02:46

Thank you so much

Ответить
dunno
dunno - 16.04.2023 23:23

Excellent stuff. Exactly what I needed! Thanks so much. I am now a subscriber 😊

Ответить
Heather Hale
Heather Hale - 09.04.2023 19:09

BLESS YOU! WOW! Me, too, me, too, me too! Saved HOURS of work with 2 min super simple explanation! THANK YOU!

Ответить
Dr.Harrison Michael
Dr.Harrison Michael - 22.03.2023 16:35

Thank you very much! It was helpful!

Ответить
Sebas Giraldo (Folkboy Music)
Sebas Giraldo (Folkboy Music) - 03.03.2023 02:46

Amazing, thanks :3
You explain really good

Ответить
David
David - 24.02.2023 17:52

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

Ответить
Kristina Van Loo
Kristina Van Loo - 23.02.2023 18:38

thanks a lot!!

Ответить
Kamal Salar
Kamal Salar - 07.02.2023 20:38

Thanks Man, You saved my time

Ответить
Felix Lissaker
Felix Lissaker - 30.01.2023 16:52

You're my hero

Ответить
Celso Tuzzolo
Celso Tuzzolo - 24.01.2023 16:59

Really helpful. Thanks so much!

Ответить
TooTall Dan
TooTall Dan - 24.01.2023 00:40

Standard Hyperlinks work but Imported from a html table into excel, doesn't work.

Ответить
Lori Collier
Lori Collier - 20.01.2023 05:05

Great video!

Ответить
303 Winspear
303 Winspear - 19.01.2023 02:19

this is fantastic, but how to do this when the link is an image link?

Ответить
Łukasz Sawicki
Łukasz Sawicki - 18.01.2023 14:46

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

Ответить
Mykola Kanyuk
Mykola Kanyuk - 13.01.2023 17:27

Thank you very much, it save a lot of time for me. Subscribed

Ответить
Logesh Shanmugam
Logesh Shanmugam - 09.01.2023 13:38

Awesome!!! thank you so much!!

Ответить
Infotegra S.A.S
Infotegra S.A.S - 22.12.2022 19:55

Thank you

Ответить
Tamso Maa Jyotirgamay
Tamso Maa Jyotirgamay - 17.12.2022 12:57

Thank u so much sir
It saved my lot of time

Ответить
Mary Angela Amarillado
Mary Angela Amarillado - 14.12.2022 22:21

Thank youuuu! Such a big helppppp!

Ответить
MaximumZebra
MaximumZebra - 28.11.2022 12:43

This is incredibly useful, and appreciate the work that you have completed! Well done!

Ответить
Mandy Martens
Mandy Martens - 25.11.2022 15:16

You just saved me a ton of work, thanks!

Ответить
PRASHANA BALAJI
PRASHANA BALAJI - 24.11.2022 11:17

When iterating through excel cells ,how to find cell value has hyperlink

Ответить
FERNANDO SOUSA DOS SANTOS
FERNANDO SOUSA DOS SANTOS - 24.10.2022 16:36

Helped a lot!!!!!!!!

Ответить