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)
Thursday, June 18, 2015
Excel - Trim Trailing Text
This formula will trim all of the text in a cell after the specified criteria:
Example:
=LEFT(A2,FIND(" (",A2)-1)
Example:
=LEFT(A2,FIND(" (",A2)-1)
