Hello!

I have a very long column (almost 3000 cells) of URLs. I would like to replace them in the second column with shortened versions, basically cut them at the fourth slash.

Let me illustrate:

www.plant.edu/wm/mail/window/apple/seed

would turn into

www.plant.edu/wm/mail/window

Could you tell me how can I used functions in Excel to do it? I am not very advanced when it comes to Excel and I need help. Thank you very much.