Remove a word from a series of cells

[jah72773]

I need to remove the word "Total" from 492 cells. It is at the end of every cell. How can I do this? I tried text to columns, but I can't isolate the word. I am using Office 2010.

Example

Total Ins Weeks Total
Town Total
Transfer Sheet of Previous Labour Agency Total
Transport Allowance Total
Type of Contract Total
Type of Contract (Permanent/Temporary) Total
Type of Medical Scheme Total
Unemployment Card Total


Thanks,
Jennifer

[dominicb]

Good evening jah72773

Why not use the find and replace function? You can find "Total" and replace with "".
You don't need the quotes, by the way. Just leave the replace box empty.

HTH

DominicB

[jah72773]

Oh, my gosh! I am an idiot. Why didn't I think of that?