Lets say this string is in A1.
Mike Trout\troutmi01
B1 has this formula
=LEFT(A1,FIND("\",A1)-1)
And therefore the value in B1 is displayed as follows.
Mike Trout
Now in C1 i put this formula
B1="Mike Trout"
C1's value is returned as FALSE.
Why doesn't C1 return TRUE? I expected it to return TRUE. It seems like it is TRUE.
If i change the contents of B1, and instead of that formula, i just type the string "Mike Trout" (no quotes of course), then C1 correctly returns TRUE.
I see the same analogous issue with the MATCH function, if B1 has the formula, MATCH does not match the string "Mike Trout" in its arguments, but if B1 has no formula and you just type "Mike Trout" as a constant string there, it matches.
I guess my question is, how can i get equality or MATCH, to the result of a formula as i illustrate in B1, to work and return TRUE when what i am trying to match is a string that does indeed match the evaluation result of the formula in B1.
Thanks for clarifying this for me!
Mike Trout\troutmi01
B1 has this formula
=LEFT(A1,FIND("\",A1)-1)
And therefore the value in B1 is displayed as follows.
Mike Trout
Now in C1 i put this formula
B1="Mike Trout"
C1's value is returned as FALSE.
Why doesn't C1 return TRUE? I expected it to return TRUE. It seems like it is TRUE.
If i change the contents of B1, and instead of that formula, i just type the string "Mike Trout" (no quotes of course), then C1 correctly returns TRUE.
I see the same analogous issue with the MATCH function, if B1 has the formula, MATCH does not match the string "Mike Trout" in its arguments, but if B1 has no formula and you just type "Mike Trout" as a constant string there, it matches.
I guess my question is, how can i get equality or MATCH, to the result of a formula as i illustrate in B1, to work and return TRUE when what i am trying to match is a string that does indeed match the evaluation result of the formula in B1.
Thanks for clarifying this for me!