Hi!
Thanks for letting me join the forums. Was wondering if there's a functionality in excel to do this or if I have to do some sort of VBA coding:
I have a spreadsheet of website URLs, all in one column, multiple rows, say similar to the one I attached.
I just want to extract the hostname (i.e. google.com, or cnn.com) without all the folders/subfolders/website name etc.
Is there anyway to do this?
Thanks in anticipation!
Last edited by sab336; 02-27-2022 at 09:50 PM.
Try:Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
With 365:Formula:Please Login or Register to view this content.
That was super helpful thank you!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks