AboutPricing

Get instant live expert help on I need help with excel trim not working

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.
< Go Back

    Here are some problems that our users have asked and received explanations on

    trim function is not working to eliminate the extra space at the end of the last word in the cell
    Solved by E. E. in 18 mins
    len test on cell shows more characters than appearing. After a trim. The len test still shows more characters. Hence my vlook up not working
    Solved by X. E. in 22 mins
    =IF(G10="Yes","Match Override",IF(EXACT(TRIM(B10),TRIM(F10)),"Match","No Match")) How can I clean AND trim in this formula?
    Solved by O. B. in 18 mins
    Please help me with a formula for: If D6=1 and E6=PASS,TRIM or BLEND, then 1, otherwise 0 This is what I have so far, which of course does not work: =IF(D6="1" AND E6="PASS" OR E6="TRIM" OR E6="BLEND"),"1","0"
    Solved by E. W. in 22 mins
    trying to trim and concaternate some info
    Solved by V. U. in 22 mins