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:

=TRIM(RIGHT(SUBSTITUTE(A2,"Street",REPT(" ",LEN(A2))),LEN(A2)))

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:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

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