Remove trailing characters

Text > Delete number of ending characters

This utility removes a specified number of characters from the end of selected cells.

The utility works with both numbers and text. Cells with formulas will be skipped.

To remove characters in cells with formulas, you must first convert the formulas to values.

You can, for example, use it to quickly delete the last character from all selected cells.

Screenshot

Running this tool

Click YLC Utilities > Text > Delete number of ending characters :

Do you recognize any of these situations?

• How can I remove the last 6 characters of text and use them as a cell value?
• I have a column (27422 rows). I would like to remove the last 4 characters.
• I have a long list of part numbers that end with the letter "R". I want to remove the "R" from the part number. The problem is that the "R" can also appear elsewhere in the part number, but I need it to stay in place. So I can't use the find and replace function to remove the "R".

Decision

Just select the cells and then choose the following tool from the menu Excel :

YLC Utilities » Text » Delete number of ending characters

This is a faster alternative than using a temporary column and a combination of the =LEFT(), =MID(), =RIGHT(), and =LEN() functions.

How much time will this save?

Using this tool will definitely save you time and effort. However, the actual time savings will depend on how often you use it. Excel , the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Delete number of ending characters by installing the extension YLC Utilities .

After that, this function will be available in all files that are opened in Excel .