PDA

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



sinner01
2011-04-09, 11:12 AM
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

Simon Lloyd
2011-04-09, 04:34 PM
Do you want a formula solution or VBA?
For the formula use: =SUBSTITUTE(A1,"Total","") this assumes the text to adjust is in A1

sinner01
2011-04-09, 08:14 PM
Do you want a formula solution or VBA?
For the formula use: =SUBSTITUTE(A1,"Total","") this assumes the text to adjust is in A1
thank you :clap2:neat solution