Skip to main content

Extract Data from a Field

  • April 15, 2019
  • 1 reply
  • 10 views
A
Forum|alt.badge.img+17

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

    A
    Forum|alt.badge.img+17
    • Abraham_Bochner
    • Author
    • Known Participant
    • April 15, 2019

    Someone on Mr. Excel helped me:

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

    M
    Justin_Barrett
    Terms & ConditionsAccessibility statement