Pull from the right until string found

November 6, 2019

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

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

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