Excel Combine First And Last Name

So you’ve got a spreadsheet full of first and last names. And you’re staring at them, thinking, “I really need these two columns to become one.” Welcome to the club; we meet every Tuesday in the breakroom, but the coffee is terrible.

The problem is simple: you have “Clark” in column A and “Kent” in column B. But you need “Clark Kent” in column C. Manually typing that for 500 rows is a special kind of digital self-harm. Let’s fix that before your eyeballs glaze over like a donut at a cop convention.

Option One: The Magical & Symbol (That Everyone Forgets)

First, the holy grail of name combining: the ampersand. It’s not just for fancy chocolate shops and old-timey typewriters. In Excel, it’s a glue gun for text.

Type this into cell C1: =A1&" "&B1. That little & symbol tells Excel, “Take A1, add a space, then add B1.” It’s like teaching your spreadsheet to say, “Nice to meet you, space, nice to meet you, too.”

Here’s a surprising fact: the ampersand is actually the oldest function in Excel, predating even the CONCATENATE function by several generations. It’s the granddaddy of name-mashing, and it still works like a champ.

Option Two: The Flashy CONCATENATE (That’s Now Just CONCAT)

Next up is the CONCATENATE function—which sounds like a wizard spell from a budget fantasy movie. You’d write: =CONCATENATE(A1," ",B1). It works, but it’s a bit wordy.

Microsoft realized we’re all lazy, so they shortened it to CONCAT in newer Excel versions. It’s like your grandpa shortening “telephone” to “phone.” Just use CONCAT and save yourself two keystrokes. You can spend those saved seconds thinking about your lunch.

Combine First and Last Name in Excel

Fun fact: CONCATENATE is actually retired by Microsoft, but it still works in Excel 2019 and older. It’s the spreadsheet equivalent of a senior citizen who refuses to stop driving—totally functional, but making everyone a little nervous.

Option Three: The Flash Fill Trick (No Formulas Needed)

Now for the brain-melting cheat code: Flash Fill. Type “Clark Kent” into cell C1 manually. Then, click cell C2 and press Ctrl+E (Windows) or Command+E (Mac). Watch Excel psychically guess what you want.

It’s like that friend who finishes your sentences, but actually helpful. The catch? You have to type the first example exactly right, or Excel will assume you want “ClarkKent” with no space, and then you’ll look like a maniac at your next team meeting.

A shocking truth: Flash Fill was originally a secret feature for Microsoft’s internal use. An engineer built it on a dare during a hackathon, and it was so good they shipped it. Excel has clandestine code just to make you look cool.

How to Combine First and Last Name in Excel: The Easy Ways to Do It

Pro Tip: Dealing with Middle Initials and Hyphenation

What if you have a “Mary Jane” as a first name? Excel gets confused, but you can outsmart it. Use =A1&" "&B1, but manually change the cell format to “Text” first. Otherwise, Excel might try to alphabetize your “Mary” with a “Tom” and give you “Marty.”

And for the love of pie, if you have a hyphenated last name like “Smith-Jones,” don’t panic. The formula loves hyphens. It thinks they’re fancy. Your spreadsheet will look like it belongs at a royal wedding.

The Punchline

So now you can combine first and last names like a spreadsheet ninja. No more copying and pasting each row. No more needing a therapist because you’re stuck in column C. Your boss will think you’re a wizard, and your coworkers will whisper, “How does she do it?”

Try it right now. Open a random spreadsheet, mash some names together, and feel the power. Just don’t try it on your dating profile; Excel can’t help you there. That’s a different kind of formula entirely.