Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kiesha
 
Posts: n/a
Default How do you subtotal but not include the word total in the cells?


  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do you subtotal but not include the word total in the cells?

Do the data|subtotals, then use Edit|replace to remove the word?



Kiesha wrote:

--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default How do you subtotal but not include the word total in the cells?

And don't forget that leading space before the word!

Dave Peterson wrote:

Do the data|subtotals, then use Edit|replace to remove the word?

Kiesha wrote:

--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Sumif Cells Are Not Blank Powlaz Excel Worksheet Functions 12 March 15th 06 05:40 PM
In several cells I have =?+423.55 I want total w/o the 423.55. lheck77 Excel Worksheet Functions 2 January 2nd 06 10:22 PM
Adding up cells that include text in them Alan Excel Discussion (Misc queries) 1 August 24th 05 08:23 PM
How do I copy data (word) into respective cells when the data bei. awg9tech New Users to Excel 1 January 12th 05 12:26 PM
Whats the function to count the total times a word is displayed Monk Excel Discussion (Misc queries) 3 December 10th 04 11:39 PM


All times are GMT +1. The time now is 11:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"