Replace/Substitute Function

HiroShima Nagasaki Company Limited (TSX:3454) and Thanks Again Limited (TSX:9899) (Cell A1)

I want this company name without ticker symbol in Cell A2

eg: cell A2 should have :

HiroShima Nagasaki Company Limited

Similarly If change company name in Cell A1, it should come as the given example in Cell A2

eg. Cell A2 should have

Thanks Again Limited

Hi,

Try the following in A2:

=LEFT(A1,SEARCH("(",A1,1)-2)

Thanks a lot!