IF function for two columns in diffent cases

[Guest]

I have two columns that I need to compare and get a TRUE or FALSE answer on
if the text in the columns match. The problem is that the case of the text
in the two columns is different. One column is in all CAPS and the other is
using Proper formatting. I have tried using the IF function after converting
one column to all CAPS using the UPPER formula, but it still returns a FALSE
even if the colums match. Is there another way to get a TRUE or FALSE since
the cases do not match?

Thank you!

 

[Bob Phillips]

Doesn't sound like case is the problem. Try TRIM ing the cells to remove any
leading/trailing spaces.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Bernie Deitrick]

pt_lily,

=A1=B1

will return TRUE independent of case.

You would actually need to use =EXACT(A1,B1) to show differences in case.

HTH,
Bernie
MS Excel MVP

 

[Guest]

Thank you for the help. That seems to be what the problem is. All of the
text in one of the columns has several trailing spaces at the end. Is there
a way to get rid of these without doing it all manually? My spreadsheet has
about 6,000 lines.

Thanks again!

 

[Bob Phillips]

Just cater for it in the formula

TRIM(B3) for instance

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)