Results 1 to 3 of 3

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files
    Last edited by sinner01; 2011-04-09 at 11:15 AM. Reason: need attatchment

  2. #2
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    324
    Articles
    0
    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 by Simon Lloyd; 2011-04-09 at 04:39 PM.
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion

  3. #3
    Quote Originally Posted by Simon Lloyd View Post
    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 neat solution

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •