Hello. I'm trying to get some information from within a cell. As I'm working with URLs, the first bit is the same in all of them but I need to get the bit that's different isolated in a separate cell. Does anyone know a quicker way of doing this?

For example:
I cell A1 I have the full URL: /products/acrylic-colours/artists-acrylic-colour-/colour-chart/antique-gold/ ("antique-gold" is the bit of the URL I want to isolate).

In cell B1 I have the formula:=SUBSTITUTE(A1,TRIM(RIGHT(LEFT(SUBSTITUTE(A1,"chart/",REPT(" ",100)),100),100)),"") which returns "chart/antique-gold/"

In cell C1 I have the formula: =RIGHT(B1, LEN(B1)-6) which returns "antique-gold"

Is there a way to combine these 3 formulas so in cell B1 I can get the result "antique-gold"? This needs to be scalable as well to hundreds of URLs. But what they all have in common is /products/acrylic-colours/artists-acrylic-colour-/colour-chart/ at the beginning and a backslash on the end.

Thanks in advance.