The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Extract Data from a Field

posted Apr 15, 2019 5:29:20 AM

0 1346 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

1 Reply 1

Someone on Mr. Excel helped me:

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