ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Subtotal results without word "Total" (https://www.excelbanter.com/excel-worksheet-functions/45077-subtotal-results-without-word-%22total%22.html)

achidsey

Subtotal results without word "Total"
 
Excel Experts

When inserting Subtotals, isn't there a way to get the results without
having the word "Total" appended to each Totaled Item?

I knew this once.

Thanks
Alan


--
achidsey

Dave Peterson

I don't think so, but you could always just select that column
Edit|replace
what: _Total (underscore represents a space)
with: (leave blank)
replace all

achidsey wrote:

Excel Experts

When inserting Subtotals, isn't there a way to get the results without
having the word "Total" appended to each Totaled Item?

I knew this once.

Thanks
Alan

--
achidsey


--

Dave Peterson


All times are GMT +1. The time now is 06:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com