Trim, Lfft, Right...Is there a combination of these functions that will remove a word

S

sinner01

New member
Joined
Apr 7, 2011
Messages
6
Reaction score
0
Points
0
Hi
Is it possibel to remove the word Total from this set of data?
FamilyAnimal TotalBought in Retail TotalBreast Pads TotalDry Wipes TotalInco TotalInstrapac TotalMaternity TotalMedical CW TotalPlasters TotalPlastic Speculum TotalRetail CW TotalWet Wipes TotalWoundcare TotalGrand Total
Cheers
 

Attachments

  • Book1.xlsx
    8.3 KB · Views: 15
Last edited:
Do you want a formula solution or VBA?
For the formula use: =SUBSTITUTE(A1,"Total","") this assumes the text to adjust is in A1
 
Last edited:
You must log in or register to reply here.
Back
Top