True false function for alpha data

[R Y]

Row # Column1 Column2 Outcome
1 80E 80E TRUE
2 999 80E FLASE
3 80E 80E TRUE
4 CB1 80E FALSE
5 80E 80E TRUE
6 999 80E FALSE
7 999 C76 FALSE

I'm trying to write a formula that gives me a true/false outcome for the
above data and the results would be where the outcome is located (completed
manualy)

 

[Bernd P]

Enter into C1:
=A1=B1
and copy down.

Regards,
Bernd

 

[Gary''s Student]

In C1 enter:

=(A1=B1)
and copy down

 

[Bernard Liengme]

Need more indo, I think
best wishes

 

[Gord Dibben]

In C1 enter =B1=A1

Copy down.


Gord Dibben MS Excel MVP

 

[Dana DeLouis]

I'm trying to write a formula that gives me a true/false outcome...

One additional idea might be:

=EXACT(A1,B1)

One difference is that if the strings are
80E & 80e, then Exact() would return False.
= = = =
Dana DeLouis

 

[R Y]

When I tried this I received all false outcomes.

Column1 Column2 =(A1=B1) Should Be
80E 80E FALSE TRUE
999 80E FALSE FALSE
80E 80E FALSE TRUE
999 80E FALSE FALSE
80E 80E FALSE TRUE
999 80E FALSE FALSE
999 C76 FALSE FALSE
C76 C76 FALSE TRUE
999 A09 FALSE FALSE
71O 52 FALSE FALSE
71O 52 FALSE FALSE

 

[David Biddulph]

Have you checked for spare spaces or other non-printing characters?
What do you get for =LEN(A1) and =LEN(B1), copied down as appropriate?