Help Extracting Text from Cell after last "/"

[maximillianrg]

Hello Excel Masters

I'm writing to ask for help in creating a formula that will locate the last "/" in cell A1 and return all the text following the final "/" as shown below.


A1 = https://drive.google.com/drive/folders/1Lamt3zl4JR_6_-5x653edXt1oY7t6HbX'
B1 = 1Lamt3zl4JR_6_-5x653edXt1oY7t6HbX

Conditions
- Contents in Cell A1 can vary greatly in length
- The number of "/" in Cell A1 can range from 5-20

 

[Fluff]

How about

=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",500)),500))

 

[maximillianrg]

How about

=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",500)),500))

Hello and Thank you Fluff

That formula worked absolutely perfect for returning the value I I was looking for in my example but after doing a fill down, I wanted to ask if you can help modify it a bit more?

A1 = Google Drive: Sign-in
B1 = 1kFLhrpaNFXwFJU1bNrLZzJF5nbeU5KVA

In some cases A1 may have the contents "?usp=sharing" after the string. Can the formula be modified to also locate and strip out "?usp=sharing" if it exists?

 

[Fluff]

Try

=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",500)),500)),"?usp=sharing","")

 

[maximillianrg]

That also worked perfectly - Thank you soooooo much Fluff - Have a great weekend!

 

[Fluff]

You're welcome & thanks for the feedback.