Thread: Removing the word "Total" from subtotal cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default Removing the word "Total" from subtotal cells
Hi Andy

One way is to use EditReplace in the menu bar

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Andy F." wrote in message ...
I'm using Excel 2002. I've taken a list with 6000 rows of data and used the "Subtotals" instruction to find summary data for the
334 item numbers that are repeated through the list. I would like to copy the item numbers into another list but the subtotals
include the word "Total" in the cell. For example: the multiple rows of data with item # L6050 is subtotaled into a cell that says
L6050 Total. Is there someway to remove the word "Total" from the cell?


Reply With QuoteReply With Quote