I need to extract the characters to the right of the hyphen in the column below (Labels3).
I do not have the option on the Data Source tab to split the field.
I found a workbook example using SPLIT, but my version (10.1) is not recognizing the function.
Is there a way to quickly extract the characters I need with a calculated field? Sorry I cannot share data due to security restrictions.
As an alternative, you can use combinations of other string functions:
RIGHT([Test], LEN([Test]) - FIND([Test], "-"))