Formula to get a specific value in string between periods

Question

AAAAAAAAAAA.BBB.CCCC.DD.EEEEEE.F.G.

Note the lengths will vary for each value between periods. I need to return just the value of G in this string. G will sometimes be two digits and sometimes one digit. It will always have a period at the end and the string will be terminated after the period.

Answer 1

Please try:

=SUBSTITUTE(RIGHT(A1,3),".","")