Split SharePoint column into 3 calculated columns using delimiter

Yatin Purohit 21 Reputation points

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.

A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
5,994 questions
No comments
{count} votes

Accepted answer
  1. Emily Du-MSFT 24,311 Reputation points Microsoft Employee

    @Yatin Purohit

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


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


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



    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.

0 additional answers

Sort by: Most helpful