How to remove the last character in Excel
By
SpreadCheaters
You can watch a video tutorial here.
Many applications offer you the option of exporting data to Excel. When working with data that has been exported from another application you will frequently need to clean and format the data so that you can proceed to analyze or summarize it. One such operation could be to remove the last character in some text. This can be done using a combination of the LEFT() and LEN() functions in Excel.
Step 1 – Create the formula
– Select the destination cell
– Type the formula using the cell references for Name:
= LEFT(Name,LEN(Name)-1)
The LEFT() function returns the specified number of characters from the left of the text
Since we want all characters except the last one, we use the length of the text (LEN(Name)) and reduce it by 1
– Press Enter
– The last character has been removed
Step 2 – Copy the formula
– Using the fill handle from the first cell, drag the formula to the remaining cells
OR
a) Select the cell with the formula and press Ctrl+C or choose Copy from the context menu (right-click)
b) Select the rest of the cells in the column and press Ctrl+V or choose Paste from the context menu (right-click)
