ramon
Reputation: 73
Excel formula: How do I remove last two digits or last two letters in column?
For example:
How do I remove the last 2 letters or digits on the next column?
Upvotes: 0
Views: 39261
Answers (2)
Miguel_Ryu
Reputation: 1418
This Should do it.
=LEFT(A1,LEN(A1)-2)
What we do in the formula is ask for the Left side of the text from the total string lenght minus two, which removes the 2 last characters in the string.
Upvotes: 0
Karthick Gunasekaran
Reputation: 2713
Assuming your data starts with A1 and apply the below formula in b1 and drag down (select B1 to B11 and CTRL + D)
=RIGHT(A1,2)
Upvotes: 1
Related Questions
- Removing first two digits in Excel if the character length is greater than certain number
- How to remove all first characters if all are digits in excel
- Removing all numbers and letters after a specific character
- How can I remove the all the characters after second "." from the right in excel?
- Excel: Delete Last Word In String IF it is a number
- Remove last two characters in cell
- Remove the beginning characters in a cell while maintaining the formula for removing the trailing characters
- extract last number from the right until special character
- Remove the last two Characters in a cell
- How do I remove all but the "first" 3 characters in a cell in MS Excel 2010?