Extract part of text from one cell with a long URL with folders - help!

[darthtom6]

Hi!

I've got a tricky question, I've got a list of URL from a big website in a single cell, eg:
http://aaa.111.pl/cms/portal/brand/c.../product_name/

This is for a few brands, product categories, etc. - so please bear in mind that the number of letters between each /xxxxxxx/ are dynamic.

From the one cell that I have I need to extract to B column the first part so the domain, so a few examples below based on columns:

A: http://aaa.111.de/cms/portal/brand/c.../product_name/

B: aaa.111.de

C: brand

D: country

E: EU-category

F: prod-information

etc.

But keep in mind that sometimes the name of the domain is insted of aaa.111.de different BB.33333.eu.
So the numbers of letters are different but we can 'catch' the part in between two / / but... I don't know how to make it work.

Please help.

[darthtom6]

Any ideas? I wasted 3 hours looking for this and nothing :/

[AlKey]

Try this one in B1 and pull formula to the right until you see blanks

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($A1,"http:/",""),"/",REPT(" ",255)),255*COLUMNS($A:A),255))

[Richard Buttrey]

Hi,

Try

Please Login or Register  to view this content.

[Richard Buttrey]

@Alkey,

Much neater. I like it