Search code examples
stringexcelexcel-formulaworksheet-functionsubstitution

Formula to get a specific value in string between periods

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.

Solution

  • Please try: 

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