SharePoint calculated column remove characters from text

In this SharePoint tutorial, I will explain how to remove characters from text in the SharePoint calculated column. I will show you how to use the LEFT, RIGHT, and MID functions to remove characters from a text in a SharePoint calculated column.

Table of Contents

Remove characters from a text in SharePoint calculated column using the RIGHT function

In this section, I will show you how to remove characters from a text in SharePoint calculated column using the RIGHT function.

In the RIGHT function, the characters from a text remove from left to right direction. To achieve it, follow the below steps.

Open a SharePoint Online list, click on the + Add column, and select See all column types -> Click on Next. Then enter the Column name and select Calculated (calculation based on other columns).
Insert the formula to remove characters in the SharePoint calculated column in the Formula box, then click OK.

Syntax to remove characters from a text in SharePoint calculated column using the RIGHT function:

=RIGHT([Column1], LEN([Column1]))-5)

The formula used to remove characters from a text in SharePoint calculated column using the RIGHT function. Here, I have used the Title column.

=RIGHT([Title], LEN([Title]))-5)

The screenshot below shows the output where characters remove from left to right direction.

This is how to remove characters in a text in SharePoint calculated column using the RIGHT function.

SharePoint calculated column remove characters in a text using the LEFT function

Let’s see how to remove characters from a text in SharePoint Online calculated column using the LEFT function.

Here, the characters from a text remove from right to left direction. To do it, follow the below steps.

Go to the Edit column tab using the steps of the previous section, then insert the formula in the Formula box.

The syntax used to remove characters from a text in SharePoint calculated column using the LEFT function is listed below.

=LEFT([Column1], LEN([Column1])-8)

The formula used to remove 10 characters from a text in SharePoint calculated column using the LEFT function is given below. Here, I have replaced Column 1 with the Title as per the need.

=LEFT([Title], LEN([Title])-10)

SharePoint Online calculated column removes characters

Then click OK, and now you can see the output as I have removed the 10 characters from the left side in a text in the SharePoint calculated column below.

This is how to remove characters in a text in SharePoint Online calculated column using the LEFT function.

Remove characters in a text from SharePoint calculated column using the MID function

I will show you how to remove characters in a text in the SharePoint calculated column using the MID function.

Go to the Edit column tab using the steps of the previous section, then enter the formula in the Formula box. I have changed the number as per my need -> Click on the OK button.

The syntax used to remove characters from a text in SharePoint calculated column using the MID function is listed below.

=MID([Column 1], 4, LEN([Column 1])-7)

The formula used to remove characters from a text in SharePoint calculated column using the MID function listed below:

=MID([Title], 4, LEN([Title])-11)

The screenshot below shows the SharePoint calculated column output that removes characters in a text using the MID function.

This is how SharePoint calculated column removes characters from a text using the MID function.

Conclusion

In this SharePoint Online tutorial, I have explained how to remove characters from a text in SharePoint calculated column using the RIGHT function, which removes the text from left to right direction. Then I have shown you how SharePoint Online calculated column removes text from right to left direction using the LEFT function. Moreover, I have explained how to remove characters from a text using the MID function, which removes text from both ends in SharePoint Online calculated column.