Greetings.

I'm looking to extract parts of data from a column. However, the part of data that needs extracting can vary. For example, I may see something like 0101677/1788 (I want to extract the 1788), or 1245-5104651 (I want to extract the 1245).

Currently I'm using a formula like this:
=RIGHT(Q357,LEN(Q357)-FIND("/",Q357))

This example will pull the 1788 from the reference example I cited above. However, I'm having a challenging time in writing something that will pull the 1788 example and the 1245 example in the same formula. As you can see from the formula...Q357, I'm dealing with hundreds of rows.

Hope this is explained well enough. Thanks in advance for any support.

Vr,
V-Clan