I want to cut out substrings from this url XYZ.com/de/haus/dach/ and put the values each in its own columns in Google Spreadsheet.

With this url example:

• Column A should be "de"
• Column B should be "haus"
• Column C should be "dach"

How can I do that?

CodePudding user response：

1. Remove the characters before the first /. This can be done in a number of ways, including