How to delete the last character in Excel
Deleting the last character in Excel refers to removing the rightmost character from a text string within a cell. The overall importance of deleting the last character in Excel lies in the ability to manipulate and modify textual data effectively.
Our dataset has a list of product numbers, and each number ends with a hashtag. Our objective is to delete this last character from each number. To achieve this we have two methods that are explained below.

Method 1: Delete the Last Character using the Replace option
Step 1 – Select the Cell

- Click on the cell where you want to show the result
Step 2 – Use the Replace function

- After selecting the cell, use the Replace function by typing:
- =REPALACE(
Step 3 – Type the Argument

- Afterward, type the arguments of REPLACE function as follow:
- =REPLACE(A2,LEN(A2),1,””)
A2: This refers to the cell containing the text string you want to modify.
LEN(A2): The LEN function is used to calculate the length of the text string in cell A2. It determines the position of the last character in the string.
1: This specifies the number of characters you want to replace. In this case, it is set to 1, indicating that we want to replace the last character only.
“”: The empty quotation marks denote that we want to replace the last character with nothing, effectively deleting it.
Step 4 – Press the Enter key

- Press the ENTER key after typing the arguments to get the result in the cell
Step 5 – Copy the Function in Column

- After getting the result in the cell, drag the cell down in the column till the required cell
Method 2: Delete the Last Character using the LEFT function
Step 1 – Select the Cell

- Click on the cell where you want to show the result
Step 2 – Use the TRIM function

- After selecting the cell, use the TRIM function by typing:
- =TRIM(
Step 3 – Type the Argument

- Afterward, type the arguments of the TRIM function as follow:
- =TRIM(LEFT(A2,LEN(A2)-1))
A2: This refers to the cell containing the text string you want to modify.
LEN(A2): The LEN function calculates the length of the text string in cell A2, giving the total number of characters.
LEN(A2)-1: Subtracts 1 from the length to exclude the last character.
LEFT(A2, LEN(A2)-1): The LEFT function takes the leftmost characters from cell A2, excluding the last character based on the calculated length.
TRIM(LEFT(A2, LEN(A2)-1)): The TRIM function deletes any leading or trailing spaces from the result.
Step 4 – Press the Enter key

- Press the ENTER key after typing the arguments to get the result in the cell
Step 5 – Copy the Function in Column

- After getting the result in the cell, drag the cell down in the column till the required cell