How to extract domain name from a text string

Hi guys,

I would really appreciate it if anyone could help me with this task.

I have one column of data:
http://www.domainA.com/some-text-her...X.com-12345678
http://www.domainA.com/some-text-her...Y.org-23456789
....

There’s about 1000 lines of this data with different domain names in the end of each text string.

Is there any easy way to extract domain name from these strings? In this example I need to have the output like this:
domainX.com
domainY.org

Could please anyone help me with the best approach to accomplish this task?

Thank you in advance!

Please Login or Register  to view this content.

Try

=LEFT(SUBSTITUTE(A2,"http://www.",""),FIND("/",SUBSTITUTE(A2,"http://www.",""),1)-1)

Over-complicated solution!!!

Thanks, but I need to note that I don't need to extract the domain name which is constant and is in the beginning of each string http://www.domainA.com
I need to extract these:
domainX.com
domainY.org

I think you'll need to provide a larger set of examples that covers all possible formats of the original url string.
And show expected results for each.

Can you attach a sample Excel File, click 'Go Advanced' - 'Manage attatchments'

Originally Posted by Jonmo1

I think you'll need to provide a larger set of examples that covers all possible formats of the original url string.
And show expected results for each.

Can you attach a sample Excel File, click 'Go Advanced' - 'Manage attatchments'

Sure. Please find attached the requested file.

Originally Posted by Tony Valko

Kind of long but it works...

=LEFT(TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",255)),255)),
FIND("-",TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",255)),255)))-1)

Thanks a lot!
Is it possible to make it work in case a domain has a slash symbol?
Example: decorating-homes.com

Originally Posted by Tony Valko

Does the domain name always end in dot followed by 3 characters?

.com
.org
.edu

Mostly yes.

Is the first part of the URL always the same?
h ttp://www.mythemedetector.com/mts_newspaper-wordpress-website-template-101762/

Originally Posted by Jonmo1

Is the first part of the URL always the same?
h ttp://www.mythemedetector.com/mts_newspaper-wordpress-website-template-101762/

Yes, it's always the same.

Try

=LEFT(REPLACE(A1,1,79,""),FIND("-",REPLACE(A1,1,79,""),FIND(".",REPLACE(A1,1,79,"")))-1)

Originally Posted by Jonmo1

Try

=LEFT(REPLACE(A1,1,79,""),FIND("-",REPLACE(A1,1,79,""),FIND(".",REPLACE(A1,1,79,"")))-1)

This works awesome!! Thank you so much Jonmo1!!

You're welcome

Thank you ELeGault!!