ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Remove portion of text from cells (https://www.excelbanter.com/excel-discussion-misc-queries/46989-remove-portion-text-cells.html)

glenlee

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?

Dave Peterson

Select that column and do
edit|Replace
what: _total (_ = space bar)
with: (leave blank)
replace all

glenlee wrote:

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


--

Dave Peterson


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

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