Apr 15, 2019 05:29 AM
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
Apr 15, 2019 07:44 AM
Someone on Mr. Excel helped me:
=TRIM(RIGHT(SUBSTITUTE(A3,"/",REPT(" ",100)),100))
