How To Remove First, Last Or Certain Characters From Text In Excel?

Excel functions can be used to remove characters from a text string in Excel. This article is going to talk about how to remove First or Last n number of characters from a text string.

Removing first five characters from the text string:


To remove the first 5 characters from cell A2 and put the results in cell C2, type the following formula in cell C2.

=RIGHT(A2,LEN(A2)-5)

To copy the formula to the remaining cells, double click the fill; option or drag it down to the remaining cells. See Screenshot below.


 

Removing last six characters from the text string:


To remove the last 6 characters from cell A2 and put the results in Cell C2, type the following formula in cell C2.
=LEFT(A2,LEN(A2)-6)

To copy the formula to the remaining cells, double click the fill option or drag it to down to the remaining cells. See screenshot below.

 

Leave a Reply

Your email address will not be published. Required fields are marked *