Results 1 to 3 of 3

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

  1. 2011-04-09, 12:12 PM #1
    sinner01
    sinner01 is offline
    Seeker sinner01's Avatar
    Join Date
    Apr 2011
    Posts
    6
    Articles
    0

    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 12:15 PM. Reason: need attatchment
    Reply With Quote Reply With Quote
  2. 2011-04-09, 05:34 PM #2
    Simon Lloyd
    Simon Lloyd is offline
    Administrator Simon Lloyd's Avatar
    Join Date
    Apr 2011
    Location
    Manchester, England
    Posts
    401
    Articles
    0
    Excel Version
    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 by Simon Lloyd; 2011-04-09 at 05:39 PM.
    Kind regards,
    Simon Lloyd
    Microsoft Office Discussion
    Reply With Quote Reply With Quote
  3. 2011-04-09, 09:14 PM #3
    sinner01
    sinner01 is offline
    Seeker sinner01's Avatar
    Join Date
    Apr 2011
    Posts
    6
    Articles
    0
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

Gravatar by 1e2.it