How to use multiple =Right or =Left functions in same cell

[V-Clan]

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

[sktneer]

Assuming your string is in A1, then may be this....

Please Login or Register  to view this content.

[V-Clan]

Thank you VERY MUCH sktneer, this is perfect.

Cheers,
V-Clan

[sktneer]

You're welcome. Thanks for the feedback.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.