I know that with "&" I can add two text cells together.

How do I get rid of text?

In the example "Roddick, Andy (USA) " in A2, I want to get rid of "(USA)
". I can separate with "=right(A1,7)", the last seven characters, but how to
"subtract" them from within A2"

Felix