Extract Text from Cell: How to extract substring after specific instance of a specific character

This tutorial shows you how to extract substring after specific instance of a specific character

This particular tutorial describes how to extract substring on two examples.
First one - when we want extract substring after second occurences of the characater.
Second one - After last occurences of the character, but in case when quantity of characters changes over cells.

The functions used include QUERY(), SPLIT(), LEN(), SUBSTITUTE()

Have a great day!