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"