Thursday, June 18, 2015

Excel - Trim Trailing Text

This formula will trim all of the text in a cell after the specified criteria:

  • Sheet content to evaluate are in Column A
  • Cell A2 contains the following text:  Thomas (Tom)
  • The desired output:  Thomas
  • Cell B2 Formula to evaluate Cell A2:  =LEFT(A2,FIND(" (",A2)-1)

=LEFT(A2,FIND(" (",A2)-1)

Trim the last character in an Excel cell

Excel Formula to trim the last character from a cell

  • Text values are in Column A2
  • Place the formula below in Cell B2 to evaluate Cell A2
=LEFT(A2, LEN(A2)-1)