Excel Formula to extract text between Parenthesis (Extract This Text)



=MID(A2,FIND("(",A2)+1,FIND(")",A2)-FIND("(",A2)-1)

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)

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)