HELP: on a string

[gtben]

Hi all,

how do i cut the last part from the url without "T-Shirt-#"

for example:

url/global/Holidays/Halloween/Frightening-Pumpkin-T-Shirt-1117/ -------------return Frightening-Pumpkin
url/Holidays/Christmas/Who-Needs-Santa-Ive-Got-Grandma-T-Shirt-7391/ --- return Who-Needs-Santa-Ive-Got-Grandma
url/Couples/Hes-My-King-T-Shirt-7375/ -------------------------------------return Hes-My-King

Thanks
for your kind help!

 

[Rick Rothstein]

Hi all,

how do i cut the last part from the url without "T-Shirt-#"

for example:

url/global/Holidays/Halloween/Frightening-Pumpkin-T-Shirt-1117/ -------------return Frightening-Pumpkin
url/Holidays/Christmas/Who-Needs-Santa-Ive-Got-Grandma-T-Shirt-7391/ --- return Who-Needs-Santa-Ive-Got-Grandma
url/Couples/Hes-My-King-T-Shirt-7375/ -------------------------------------return Hes-My-King

Thanks
for your kind help!

For the sample data you posted, this appears to work...

=TRIM(RIGHT(SUBSTITUTE(TRIM(LEFT(RIGHT(SUBSTITUTE("-T-Shirt-"&A1,"-T-Shirt-",REPT(" ",299)),598),299)),"/",REPT(" ",299)),299))

 

[gtben]

For the sample data you posted, this appears to work...

=TRIM(RIGHT(SUBSTITUTE(TRIM(LEFT(RIGHT(SUBSTITUTE("-T-Shirt-"&A1,"-T-Shirt-",REPT(" ",299)),598),299)),"/",REPT(" ",299)),299))

Great!!! you are BEST!!
Thanks a lot!!

 

[Rick Rothstein]

Great!!! you are BEST!!
Thanks a lot!!

Assuming the text "-T-Shirt-" will only ever appear once in a given URL, here is a simpler formula that should also work for you...

=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,SEARCH("-T-Shirt-",A1)-1),"/",REPT(" ",299)),299))