Extract Data from a Field

#1

Hi All

I have one column with the following data:

https://spy.price2spy.com/url/41105731
https://spy.price2spy.com/url/41877130
https://spy.price2spy.com/url/41584786

I need the extract the numbers after the last " \ ".

How can I do it? What is the function to use?

Thanks in Advance

#2

Someone on Mr. Excel helped me:

=TRIM(RIGHT(SUBSTITUTE(A3,"/",REPT(" ",100)),100))

2 Likes