1

Use any of the below formula, it should work for you: =LEFT([OriginalID], LEN([OriginalID])-3) OR =LEFT([OriginalID], INT(FIND("-", [OriginalID])-1)) Output: Microsoft documentation: LEFT function LEN function FIND function


1

It seems the formula shall be like =LEFT([OriginalID],LEN([OriginalID])-3) The parentheses are not in the right position


1

Providing the formula with some assumptions. Need to update based on your input text. Assuming there is a [space] between comma and the next value like 23%, 50% Assuming percent value can be 1-digit (8%), 2-digit (88%) or 3-digit (546%) =IF(ISERROR(SEARCH(",",[COL], LEN([COL])-3)), IF(ISERROR(SEARCH(",",[COL], LEN(COL)-4)), IF(ISERROR(...


Only top voted, non community-wiki answers of a minimum length are eligible