Split SharePoint column into 3 calculated columns using delimiter

Question

In a SharePoint custom list called Vehicles, I have the column Title which is enrtered by a user.

The user will enter data as <car>-<model>-<trim>. For example, BMW-5 Series-530i Sport. I want 3 calculated populated - Make, Model, Trim, in my example the values will be BMW, 5 Series, 530i Sport in respective columns. I was hoping a combination of LEFT, RIGHT, FIND would work, but I am not able get the right formulas. Can someone help?

I am looking for native SharePoint calculated column formula and not any type of script or code. Thanks in advance.

Answer 1

@Yatin Purohit

1.In the "car" calculated column, please use following formula.

LEFT([test],FIND("-",[test])-1)  

2.In the "model" calculated column, please use following formula.

LEFT(RIGHT(Title,LEN(Title)-FIND("-",Title)),FIND("-",RIGHT(Title,LEN(Title)-FIND("-",Title)))-1)  

3.In the "trim" calculated column, please use following formula.

RIGHT(RIGHT([Title],LEN([Title])-FIND("-",[Title])),LEN(RIGHT([Title],LEN([Title])-FIND("-",[Title])))-FIND("-",RIGHT([Title],LEN([Title])-FIND("-",[Title]))))  

4.Result.

---

If an Answer is helpful, please click "Accept Answer" and upvote it
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.