There's a quiet kind of genius in this question, and it's worth pausing to appreciate it. The user isn't asking for a complicated macro or a script. They're looking at a column of names like "PAUL Hughes" and "Donald M NelSON," and they want a formula that pulls out only the uppercase parts. That's it. No AI, no machine learning, just a simple, repeatable solution. And yet, the request reveals something important about how most people actually use spreadsheets: they're not trying to build systems, they're trying to get unblocked.
The answer, as it often turns out, is a combination of Excel's array functions and a bit of creative thinking. The logic is straightforward: split the name into its individual words, check which ones are fully uppercase, and then join them back together. In practice, that means using something like `TEXTJOIN` with a filter on `ISUPPER` after splitting by spaces. For the example given, the formula would correctly return "PAUL" from "PAUL Hughes," "COX" from "Zachary COX," and an empty string for "Alan Murphy" because none of the words are entirely uppercase. It even handles the trickier cases: "M" from "Donald M NelSON" and "BILLY JEAN KING" as a complete string.
What's striking here is not the formula itself, but what it represents. This user is doing something we see constantly in our community: they're hitting a wall with messy, real-world data, and they're asking for a practical, no-nonsense fix. They're not looking for a lecture on data hygiene or a recommendation to migrate to a database. They want a formula they can paste, test, and move on from. That's not a limitation. That's a strength. It means they understand their own workflow well enough to know that a targeted solution is more valuable than a grand redesign.
This is exactly the kind of problem that makes spreadsheet work feel rewarding. It's small, it's specific, and once you see the pattern, it clicks. The user's request is a reminder that the best formulas aren't the ones that do everything. They're the ones that do one thing elegantly. And in this case, the elegance is in the logic: identify the uppercase words, ignore the rest, and present what remains. No fluff, no edge cases that don't matter, just a clean result that matches the user's intent.
If you're the one asking this question, take a moment to appreciate that you're already thinking the right way. You didn't ask for a script. You didn't ask for a plugin. You asked for a formula, which means you're ready to understand the mechanics behind it. That curiosity is what separates people who copy answers from people who solve problems. So go ahead, try the formula, break it, tweak it, and see what happens when you add a middle initial or a hyphenated last name. Because once you see how this works, you'll start spotting patterns in your data that you never noticed before. And that's the real payoff.