Ask Your Question

Rico's profile - activity

2014-07-17 12:12:10 +0200 received badge  Popular Question (source)
2014-07-17 12:12:10 +0200 received badge  Notable Question (source)
2014-07-17 12:12:10 +0200 received badge  Famous Question (source)
2013-04-25 10:42:13 +0200 asked a question Get last position of a character in a string

Hi

I need to get sections of an url which looks like this:

http://www.thewebsiteineed.com/cell/Orange-SIM/Orange/Orange-Racoon-15-SIM-Only-(1mth)/546562131

I can use the =LEFT() and =RIGHT() functions, but the length of the string can change. How do I get =RIGHT(A1, [las position of /]).

For good measure, can I get the penultimate instance of / too? So I can bring out /Orange-Racoon-15-SIM-Only-(1mth)/546562131

Thanks in advance