glenlee

Posts: n/a

Remove portion of text from cells

When subtotating, the subtotal row shows as "John Smith Total". How
do you remove the word Total from all the subtotal rows?

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
Formulas dealing with text data	Bagia	Excel Worksheet Functions	6	June 20th 05 10:29 PM
counting text cells	Debbie	Excel Worksheet Functions	4	February 8th 05 09:00 PM
Searching for text in cells	Matt	Excel Discussion (Misc queries)	1	January 31st 05 03:16 AM
How do I get merged cells to display all text.	Excel problem	Excel Discussion (Misc queries)	2	November 30th 04 04:29 AM
blank cells that include text	Cally	Excel Worksheet Functions	3	November 5th 04 01:01 AM

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

About Us

"It's about Microsoft Excel"