get the last character from a string after a character in SharePoint Calculated Column

Question

ROY-AMD-BOL-727

I am trying to extract the last letters after the character "-".

Answer 1

You could use this formula.

=RIGHT([test],LEN([test])-FIND("-",[test],FIND("-",[test],FIND("-",[test])+1)+1))

Result: