Excel formula: How do I remove last two digits or last two letters in column?

Excel formula: How do I remove last two digits or last two letters in column?

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)

enter

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.

Excel formula: How do I remove last two digits or last two letters in column?

Leave a Reply

Your email address will not be published. Required fields are marked *