How To Remove Last Character From Each Words In Excel

We will see how we could remove last alphabet from each words in excel.

We could have two scenario for a situation like this, first we would want to remove the last character if the last character is a particular character like “s” or something.

The other scenario is that we would remove the last character irrespective of what the last character is.

We will see the conditional removal of last character.

Capture

In the data above we would want to remove the last character if the last character is “s”.




To achieve that enter the below formula in the cell B2.

=IF(RIGHT(A2,1)=”s”,LEFT(A2,LEN(A2)-1),A2)

Capture

Enter the formula and drag it till you have the data available in column A.

Capture

You could see the data I row 4 “State” has not changed as it doesn’t have “s” at the last place.

Now we will see a general form of how to remove the last character from a word in excel.

Enter the formula below in cell B2.




Capture

As you could see the “e” from “State” has also been removed.

Hope this helped.

Share The Knowledge

Random Posts

  • Replace Question Mark In Excel

    In this post we will see how to find and replace question mark “?” in excel. As a question mark […]

    Share The Knowledge
  • Check If A Date Falls In A Given Week In Excel

    This post demonstrates how we could determine if a date falls in a given week.For planning purpose we are required to […]

    Share The Knowledge
  • Replace Tilde In Excel

    We will see how to find and replace “~” in excel. As tilde is a special character in excel, it […]

    Share The Knowledge
  • Exclude Blank Dates From VLOOKUP Formula In Excel

    Exclude blank dates from being pulled in excel, exclude 00-01-1900 in vlookup from being shown in excel dates, vlookup remove 00-01-1900 from dates, exclude blank dates from vlookup formula

    Share The Knowledge

Leave a Reply