Deleting Text
 

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

Deleting Text
 

In an un-used cell, enter:

=LEFT(A2,LEN(A2)-7) then copy this cell and
paste/special/value back onto A2
--
Gary''s Student - gsnu200827


"Felix" wrote:

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