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
Related Tags
calculated-column × 1051calculated-column-formula × 335
sharepoint-online × 213
list × 144
2013 × 104
date-time × 82
2010 × 80
sharepoint-enterprise × 73
sharepoint-server × 64
custom-list × 55
sharepoint-designer × 54
column × 44
workflow × 38
lookup-column × 37
javascript × 35
sharepoint-foundation × 35
date × 26
list-view × 24
2007 × 19
sharepoint-list × 19
modern-experience × 18
infopath × 16
calendar × 16
designer-workflow × 15
document-library × 14