+ Reply to Thread
Results 1 to 7 of 7

Trim Function from the right

  1. 04-10-2025, 04:39 PM #1
    Ron Purpura
    Ron Purpura is offline
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Spencerport, NY
    MS-Off Ver
    Excel 2016
    Posts
    273

    Trim Function from the right

    Hello All
    Attached is an example of a text file converted to XLSX via the Delimiter function. I am hopeful that what I need is possible via the Trim function

    In the attached, you will see in column A that it has a nasty string of data ( that includes dates and times etc which I hope to delete) I wish to delete all of that info and just show what is in column B ( basically an episode identifier and show name) so that I can do an index/match to find which files I am missing from another spreadsheet that I will utilize the trim function as well.
    Hopefully this makes sense. Thanks in Advance
    Ron
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-10-2025, 05:08 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,459

    Re: Trim Function from the right

    Try this, copied down:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 04-10-2025, 05:13 PM #3
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,119

    Re: Trim Function from the right

    are you looking to update column A or can you create a new column using

    =MID(A3,40,1000) - see column D

    you could then if required do a COPY and PASTE>SPECIAL back into column A

    is it just coincidence that the text you want to remove is 40 characters - EDIT - see you had a reply whilst i was composing - which may answer if not always 40 characters

    otherwise you would need VBA to do that I suspect to change a column - maybe power query , neither of which I provide to forums
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  4. 04-10-2025, 05:18 PM #4
    Ron Purpura
    Ron Purpura is offline
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Spencerport, NY
    MS-Off Ver
    Excel 2016
    Posts
    273

    Re: Trim Function from the right

    WOW ! Thank you so much TMS ! I am grateful ! Is it possible to take it 1 step further and trim the " numeric identifier" just before the episode text ? My apologies if this is not the right place to ask the question
    Cheers to you !
    Reply With QuoteRegister To Reply
  5. 04-10-2025, 05:21 PM #5
    Ron Purpura
    Ron Purpura is offline
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Spencerport, NY
    MS-Off Ver
    Excel 2016
    Posts
    273

    Re: Trim Function from the right

    Creating a new column with your formula works perfectly as well etaf ! Thanks so much from the states
    Cheers !
    Reply With QuoteRegister To Reply
  6. 04-10-2025, 05:50 PM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,459

    Re: Trim Function from the right

    You're welcome. Thanks for the rep.

    This for the rider:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 04-10-2025, 05:51 PM #7
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,459

    Re: Trim Function from the right

    If you have upgrade to 365, it could be shorter.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Remove Spaces between words with dashes (TRIM function, SUBSTITUTE function, CLEAN or LEN)
    By bjnockle in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-10-2023, 10:18 AM
  2. TRIM function or CHAR function? Or something I cannot figure out!
    By hklen in forum Excel General
    Replies: 8
    Last Post: 01-22-2017, 08:02 PM
  3. [SOLVED] Using Trim Function to remove excess space in Sumif function
    By st_judeu@yahoo.com in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-08-2013, 05:10 PM
  4. Trying to trim a trailing space char and the Trim function isn't working
    By Psychochook in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2007, 11:28 PM
  5. trim function-how would one incorporate the trim function within the if statement?
    By specter@doom.com in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-29-2005, 11:10 PM
  6. [SOLVED] Trim Function
    By Steved in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  7. [SOLVED] Trim Function
    By Steved in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1