Hello everyone,
I'm kind of in a pickle. So here's what I need:
<colgroup><col span="3"></colgroup><tbody>
</tbody>
So there are my columns for example. I need a formula to compare first three characters in columns A and B. If they match, come up as TRUE instead of FALSE. Basically I want to ditch the + sign. It's irrelevant. I have thousands of these rows, so I can't do it manually.
Help! :D
Thank you! ^^
I'm kind of in a pickle. So here's what I need:
A | B | C |
R5 | R6L+ | FALSE |
R5 | R6L+ | FALSE |
R5 | R6L+ | FALSE |
R5 | R6L+ | FALSE |
R6L | R6L+ | FALSE |
R5 | R6L+ | FALSE |
R5 | R6L+ | FALSE |
R6L | R6L+ | FALSE |
R6L | R6L+ | FALSE |
<colgroup><col span="3"></colgroup><tbody>
</tbody>
So there are my columns for example. I need a formula to compare first three characters in columns A and B. If they match, come up as TRUE instead of FALSE. Basically I want to ditch the + sign. It's irrelevant. I have thousands of these rows, so I can't do it manually.
Help! :D
Thank you! ^^