Extracting a specific part of a text

[Hussein_Osseily]

Hello Everyone, 

I need your guidance to acheive this result. 

I have a column that has a counted Qty out of the total Qty 

example: 

10/25          (needed result: 25)

126/423      (needed result: 423)

1689/2013    (needed result: 2013)

How can I pull the Qty after the the "/" sometimes there is a 3 digits, 4 digits, 5 digits, not fixed ?

shall i use Right() ? shall it be nested with something to make it pull everything after the " / " ? as i cant tell how many digits after the " / " is there. 

thanks in advance 

[dbaum · Accepted solution]

SPLIT

INDEX

[Hussein_Osseily]

@dbaum Thanks for your response, shall these two expressions be used nested to acheive my result?  ? 
in Column A:
25/25
extract everything after the "/" (25 in this example) 

Am new to text extractions, never done this before, appreciate your help. 

[Hussein_Osseily]

figured it out
INDEX(SPLIT([Column A],"/"),2)
it worked , thanks