Pull from the right until string found

If you have data in a column in Excel, and you just want to pull the information from the right of a particular string in a cell, try this formula:


In this example, A2 is the cell you're pulling from, and Street is the delimiter string.

Thanks to Kamaraj for the idea posted here.