Results 1 to 6 of 6

Trim Function

Threaded View

  1. 08-13-2019, 02:27 PM #1
    Ron Purpura
    Ron Purpura is offline
    Forum Contributor
    Join Date
    01-28-2013
    Location
    Spencerport, NY
    MS-Off Ver
    Excel 2016
    Posts
    270

    Trim Function

    Hello All
    Could use some help with the trim function ( I think)
    Attached you will find a data set that was imported with the < symbol and the text "min" in columns C and D. I wish to drop the < sign and the word "min" from every cell that contains these criteria in columns C and D and place the values in their respective columns of E and F so that I may total the time in Column G. You will see that I am using the TRIM function to drop the "min" text but dont know how to drop the < symbol when it is present in the column.
    Any help is appreciated.
    Thanks in advance
    Ron
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Trim function ?
    By Ron Purpura in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 09-11-2017, 08:18 PM
  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 [email protected] in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-08-2013, 05:10 PM
  4. trim function
    By noobnxcl in forum Excel General
    Replies: 5
    Last Post: 02-11-2009, 04:21 AM
  5. 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
  6. trim function-how would one incorporate the trim function within the if statement?
    By [email protected] in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-29-2005, 11:10 PM
  7. [SOLVED] Trim Function
    By Steved in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM

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