Search

Thursday, June 18, 2015

Excel - Trim Trailing Text

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

Example:
  • 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)