TRIM, LEFT, RIGHT

C

cware

Can someone tell me how to remove the word Total from each cell in a column?
The word Total is at the end of every cell, and I just want to be able to
remove it with a formula of I am assuming one of the ones in my subject.

Thanks
 
G

Gord Dibben

Would Edit>Replace work for you?

Replace: Total

With: nothing


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating bolded text exclusively. 0
Remove Identical words 0
Autonumber field in Excel that behaves the same as Access 0
Consolidation Table from Different Excel Tabs with Different Format 1
How can the font and size of (all) citation numbers be altered? 1
Word VBA - Delete text from bulleted paragraphs 1
How to remove a bracket that is itallicised for an entire document 1
How to implement two shifts per day with multiple teams 0

Top