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.

Contact Me With Your Litigation Support Questions:


  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com