| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting text in a column | Excel Discussion (Misc queries) | |||
| Deleting Text Boxes | Excel Worksheet Functions | |||
| Deleting some text from a cell | Excel Worksheet Functions | |||
| deleting a Text Box in a worksheet | Excel Worksheet Functions | |||
| Deleting 3 Text characters from the right | Excel Worksheet Functions | |||
Linear Mode
