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