View Single Post
 
Old 09-17-2018, 06:38 AM
14spar15 14spar15 is offline Windows XP Office 2000
Advanced Beginner
 
Join Date: Mar 2011
Posts: 97
14spar15 is on a distinguished road
Default Extract Text To left of nth "/"

This works well for trimming everything AFTER the 3rd “/”. I can change the 3 to fit different needs such as 4 for 4th “/”.
LEFT(A1,FIND("^^",SUBSTITUTE(A1,"/,","^^",3))-1)
https://www.page.com/product/ford/13...b7123fb76b963b
Returns this
https://www.page.com


I was hoping this would work to trim everything BEFORE and including the 3rd “/” but it is not giving me the results I was expecting.
RIGHT(A1,FIND("^^",SUBSTITUTE(A1,"/,","^^",3))-1)
https://www.page.com/product/ford/13...b7123fb76b963b
Returns this
65a19eb7123fb76b963b
Reply With Quote