|
|
#1
09-17-2018, 06:38 AM
|
|||
|
|||
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 
|
|
#2
09-17-2018, 08:39 AM
|
||||
|
||||
|
Like this ?
=SUBSTITUTE(A1,LEFT(A1,FIND("%",SUBSTITUTE(A1,"/","%",3))),"")
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|
|
|
|
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 |
Windows XP 
Office 2000
Linear Mode
