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.
![](https://static.wixstatic.com/media/af7fa4_996b2253d24749a78cc2a04506d48a05~mv2.png/v1/fill/w_75,h_43,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/af7fa4_996b2253d24749a78cc2a04506d48a05~mv2.png)
Thanks to Kamaraj for the idea posted here.