Hi,
Assume that I have these data in a column
example.com/p1/
example.com/p1/something
example.com/p1/somethingelse
example.com/p2/
example.com/p2/something
example.com/p2/somthingelse
I just want to remove all the parts after /p1/ and /p2/ and make each cell contains only the top level data. How do I do that?
ex:
example.com/p1/
example.com/p1/
example.com/p1/
example.com/p2/
example.com/p2/
example.com/p2/
You help will be highly appreciable as I have thousands of data like this.
Thanks,
Thanks
Bookmarks