Extract numbers after the last /

[eaxlns]

Hello, I need a formula to extract the last group of numbers found at the end of the following URL:

https://www.costco.co.uk/Appliances/Vacuums-Floorcare/Rug-Doctor-Deep-Carpet-Cleaner-with-2-x-1L-Carpet-Detergent/p/248449

In this case there are 6 numbers but it can vary so any formula limited to 6 numbers won't work.

Thanks for your help!

 

[sandy666]

with Power Query (Get&Transform)

url		url
https://www.costco.co.uk/Appliances/Vacuums-Floorcare/Rug-Doctor-Deep-Carpet-Cleaner-with-2-x-1L-Carpet-Detergent/p/248449		248449

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Extract = Table.TransformColumns(Source, {{"url", each Text.AfterDelimiter(_, "/", {0, RelativePosition.FromEnd}), type text}})
in
    Extract

 

[Joe4]

How about this (for an entry in cell A1):
=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",100)),100))

 

[eaxlns]

How about this (for an entry in cell A1):
=TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",100)),100))

Thanks this work!

 

[Joe4]

Thanks this work!

You are welcome.