Extract Text To left of nth "/"

14spar15 · #1 09-17-2018, 06:38 AM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
extract email from google search "help" please " i can pay no problem after test"	mohamedabdu	Excel Programming	1	08-22-2018 07:43 PM
The "body of text" for all odd-numbered pages are all "vertically-centered-aligned".	keepcalmandreadabook	Word	5	03-27-2017 04:08 PM
"Temporary" files that show up on the left of page	livemusic	Word	4	05-28-2015 04:10 PM
Extract image from pdf file to "word"	026173	Drawing and Graphics	1	11-14-2013 03:13 AM
Why the left edge of an inserted table is out "text boundary" by default?	Jamal NUMAN	Word Tables	2	06-30-2011 04:47 PM