Deleting Text

  • Thread starter Thread starter Felix
  • Start date Start date
F

Felix

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
 
In an un-used cell, enter:

=LEFT(A2,LEN(A2)-7) then copy this cell and
paste/special/value back onto A2
 
Back
Top