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.