
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
1 Reply 1

Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 15, 2019 07:44 AM
Someone on Mr. Excel helped me:
=TRIM(RIGHT(SUBSTITUTE(A3,"/",REPT(" ",100)),100))
Reply
