There's a quiet beauty in the simplest formulas. The request here is almost disarmingly direct: check if the last character in A1 matches the last character in B1, and return TRUE if they do. No arrays, no scripting, no add-ons. Just a function that meets the user exactly where they are. That's the kind of problem-solving we respect most, because it doesn't ask anyone to learn a new system or rethink their workflow. It asks them to look at the tools they already have and use them more intentionally.
The practical move is straightforward: pair `RIGHT` with a comparison. Something like `=RIGHT(A1,1)=RIGHT(B1,1)` will do the trick, and it will return TRUE or FALSE based on that final character alone. For anyone who wants to be more precise about spaces or trailing characters, wrapping both sides in `TRIM` or using `LEN` to check for non-empty strings adds a layer of control without complicating the core logic. The user didn't ask for a macro or a custom function. They asked for a formula that works, and this one does.
What stands out here is the mindset, not the mechanics. The person who asked this question is thinking in terms of validation, of catching mismatches before they become bigger problems. That's the same instinct that drives better data hygiene across a whole team or organization. It's not about being fancy. It's about being correct, consistently, with as little friction as possible. And when you can solve a problem with a single line in a cell, you're not just saving time. You're building confidence in the data itself.
We'd encourage anyone who finds themselves in a similar spot to pause before reaching for a script or a plugin. Ask what the smallest reliable step is, then take it. This formula is a perfect example of that principle in action. It's accessible, it's precise, and it puts the power back in the hands of the person using the sheet. That's the kind of empowerment we like to see, and it's exactly the kind of solution worth sharing.