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.

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