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
