Extracting the last line of text from an excel spreadsheet.

[Andrewgray123]

I've got a spreadsheet of a CSV File with an export of products. This has everything i require to port over to another website, however, i do require the url Slugs.


So the format of the CSV file will show in Cell D1 for example.


http://www.mbdiy.co.uk/door-hardware-c3/door-knockers-c11/victorian-urn-door-knocker-p3
I want to keep the data from the last forward slash, everything else is simple as i can extract caterogires from the CSV no problem, but it's the last "victorian-urn-door-knocker-p3"


Any suggestions on how to achieve this will be greatly appreciated.
Kind Regards
Andy

 

[Andrewgray123]

door-hardware-c3/door-knockers-c11/victorian-urn-door-knocker-p3

 

[tonyyy]

Andy,

With "door-hardware-c3/door-knockers-c11/victorian-urn-door-knocker-p3" in cell D1, put the following formula in cell E1:

=TRIM(RIGHT(SUBSTITUTE(D1,"/",REPT(" ",LEN(D1))),LEN(D1)))

Cheers,

tonyyy