SharePoint calculated column split string

In this SharePoint Online tutorial, I will explain to you how to split string in SharePoint calculated column. Then I will show you how to split string in SharePoint Online calculated column using REPLACE function along with the FIND function.

And also, I will explain to you how SharePoint calculated column split string using the RIGHT, MID, and LEFT functions; for this, I will use three separate SharePoint calculated columns.

Split string in SharePoint calculated column

Let’s see how to split string in the SharePoint calculated column using the REPLACE and FIND functions. To achieve it, follow the steps below.

Here, I will split the string in SharePoint calculated column by replacing the ‘-‘ with ‘, ‘ using REPLACE and FIND functions.

• Open a SharePoint Online list, then click on the + Add column and click on the See all column types -> Click on Next. Inside this Create column tab, enter the Column name and choose The type of information in this column (Calculated (calculation based on other columns)).

• Then enter the formula by choosing the column from the Insert column under Additional Columns Settings, choose The data type returned from this column, and click OK as shown below.

Formula to split string in SharePoint calculated column using REPLACE and FIND function.

=REPLACE([Employee ID],FIND("-",[Employee ID]),1," , ")

• Now, you can see the SharePoint calculated column is created and show the output of the split string in the SharePoint calculated column.

This is how to split string in SharePoint Online calculated column.

SharePoint calculated column split string

Here, I want to split the string in SharePoint calculated column where I have a SharePoint column (Employee ID); from this, I want to split the Company label, Unique ID number, and Employee number.

So I will create three separate SharePoint calculated columns using LEFT, MID, and RIGHT functions. To achieve it, follow the steps below.

Split string in SharePoint calculated column using LEFT function

• Open a SharePoint Online list, click + Add column -> Select See all column types, then click Next. Inside the Create column tab, enter the column name and select The type of information in this column (Calculated (calculation based on other columns)).
• Then enter the formula in the formula box by choosing a column from the Insert column and choose The data type returned from this column, then click OK.

The formula used to split company labels using the LEFT function is listed below.

=LEFT([Employee ID],FIND("-",[Employee ID])-1)

• Now, SharePoint calculated column is created and displays the output using the LEFT function as shown below:

This is how to split string in SharePoint calculated column using the LEFT function.

Split string in SharePoint calculated column using MID function

Here, I will split the unique id numbers from the Employee ID in SharePoint calculated column using the MID function. Follow the steps below.

• Go to the Create column tab using the steps of the previous section and enter the Column name, then select The type of information in this column (Calculated (calculation based on other columns)).
• Now, enter the formula in the formula box by choosing the column from the Insert column under Additional Columns Settings. Select The data type returned from this column, then click OK.

The formula is listed below:

=MID([Employee ID],FIND("-",[Employee ID])+1,FIND("-",[Employee ID],FIND("-",[Employee ID])+1)-FIND("-",[Employee ID])-1)

• You can now see the output to split string in the SharePoint calculated column.

This is how to split string in SharePoint calculated column using MID function.

Split string in SharePoint calculated column using the RIGHT function

Using the MID function, I will split the Employee Number from the Employee ID in the SharePoint calculated column. Follow the steps below.

• Go to the Create column tab using the steps of the previous section and enter the Column name then select The type of information in this column (Calculated (calculation based on other columns)).
• Now, enter the formula in the formula box by choosing the column from the Insert column and selecting The data type returned from this column, then click on OK.

The formula used to split string in SharePoint calculated column using the RIGHT function is given below.

=RIGHT([Employee ID],LEN([Employee ID])-FIND("-",[Employee ID],FIND("-",[Employee ID])+1))

• Then you can see the output to split string in SharePoint calculated column using RIGHT function.

This is how SharePoint online calculated column split string using the RIGHT function.

Conclusion

In this SharePoint tutorial, I have explained how to split string in SharePoint calculated columns using REPLACE and FIND functions.

Then I have shown SharePoint calculated column split string using three different functions such as:

You may also like:

• SharePoint calculated column equals another column
• Add leading zeros in SharePoint calculated column
• SharePoint calculated column multiplication
• SharePoint calculated column if contains text
• SharePoint calculated column with a hyperlink
• SharePoint calculated column remove characters from text