Posted to microsoft.public.excel.newusers

Felix

external usenet poster

Posts: 78

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deleting text in a column	[email protected]	Excel Discussion (Misc queries)	6	February 22nd 08 01:09 PM
Deleting Text Boxes	Paul N	Excel Worksheet Functions	1	June 9th 07 09:59 AM
Deleting some text from a cell	Tom Petersen	Excel Worksheet Functions	5	March 19th 07 05:22 PM
deleting a Text Box in a worksheet	Excelproblem	Excel Worksheet Functions	1	July 29th 05 05:01 PM
Deleting 3 Text characters from the right	Helen	Excel Worksheet Functions	7	April 26th 05 04:17 PM

All times are GMT +1. The time now is 02:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us