How to remove N characters from the left or right side of the text.(Excel)

Japanese version.

Microsoft Excel does not have a function to delete a specified number of characters.

This article introduces methods to delete any number of characters using existing functions.

Steps.

Delete N characters from the left.

To delete a specific number of characters from the left side (beginning) of a string in Excel, use the RIGHT function and LEN function together. This method subtracts the number of characters you want to delete from the total length of the string and extracts the remaining characters from the right side.

=RIGHT(Text, LEN(Text) - Number of characters to delete)
Example of deleting two characters from the left.

Delete N characters from the right.

To delete a specific number of characters from the right end (end) of a string in Excel, use the LEFT function and LEN function together. This method subtracts the number of characters you want to delete from the total length of the string and extracts the remaining characters from the left side.

=LEFT(Text,LEN(Text)- Number of characters to delete)
Example of deleting two characters from the right.

Tips(Microsoft Excel)