Excel 2002 ( 10.6789.6714 ) SP3

when I was attempting to check if two cells had the same text , I was
getting false negatives when the two cells compared have the text MAJOR in
the cell

Is major a keyword and somehow not matching correctly?

I have other comparisons which are successfully with MINOR , CRITICAL .

I am using the function as follows =EXACT(B2,E2)

I also attempted to enter the text manually in two cells and that
comparison failed. I was importing data on original attempt.

suggestions ?
comments ?

try:

=Exact(trim(B2),trim(E2)) to remove leading/trailing blanks.

"Nfld Son" wrote:

Excel 2002 ( 10.6789.6714 ) SP3

when I was attempting to check if two cells had the same text , I was
getting false negatives when the two cells compared have the text MAJOR in
the cell

Is major a keyword and somehow not matching correctly?

I have other comparisons which are successfully with MINOR , CRITICAL .

I am using the function as follows =EXACT(B2,E2)

I also attempted to enter the text manually in two cells and that
comparison failed. I was importing data on original attempt.

suggestions ?
comments ?

that worked, thanks !

"Toppers" wrote:

try:

=Exact(trim(B2),trim(E2)) to remove leading/trailing blanks.

"Nfld Son" wrote:

Excel 2002 ( 10.6789.6714 ) SP3

when I was attempting to check if two cells had the same text , I was
getting false negatives when the two cells compared have the text MAJOR in
the cell

Is major a keyword and somehow not matching correctly?

I have other comparisons which are successfully with MINOR , CRITICAL .

I am using the function as follows =EXACT(B2,E2)

I also attempted to enter the text manually in two cells and that
comparison failed. I was importing data on original attempt.

suggestions ?
comments ?