How to remove the last character in a cell in Excel

For example, you have the following the text in a cell “A1″ and you’d like to remove the last character “s”:

“I want to remove the last character of this cells”

To remove the last character “s” from A1, use the following formula:

=LEFT(A1,LEN(A1)-1)

The result:

I want to remove the last character of this cell

Not working for you?

Remember to replace A1 with the cell that contains the string of words you want to parse out.

This entry was posted in Functions. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

6 Comments

  1. Matt
    Posted May 16, 2014 at 10:07 am | Permalink

    Thanks – perfect!!!

  2. sarma
    Posted February 18, 2014 at 7:56 am | Permalink

    its working. thanks

    • karen
      Posted February 18, 2014 at 4:43 pm | Permalink

      You’re welcome, Sarma!

  3. Murilo
    Posted August 26, 2013 at 3:19 pm | Permalink

    This way didn’t work for me, however it gave me an idea to develop this way

    =MID(A1,1,LEN(A1)-1)

    it worked perfectly, hope it helps somehow

  4. Santhanakrishnan
    Posted February 28, 2013 at 9:19 am | Permalink

    Interesting,
    Amazed by the result

    • karen
      Posted February 28, 2013 at 3:14 pm | Permalink

      Glad to hear I was able to help :)

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>