Retrieve characters after nth occurence of a string
Hi,
I have this data in my rows:
1. BBY TOYS SJC 15
2. BBY TOYS CUP 25
3. BBY TOYS SKU(15X10)10
4. SKU BOX 1000
5. SKU BOX 10000
I need to dynamically retrieve the following from each:
1. 15
2. 25
3. 10
4. 1000
5. 10000
I used the following formula:
=RIGHT(
It works for all the above rows except the 3rd, for which it retrieves: SKU(15X10)10
Can you please help? Is there a better formula that I can use?
Thanks
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago