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

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:

Simon Lloyd

Administrator
Joined
Apr 2, 2011
Messages
401
Reaction score
0
Points
0
Location
Manchester, England
Excel Version(s)
Excel 2016
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:
Top