The fastest way to add a first and last name together in Excel is to reference both cells in a formula with a space separator, such as =A2&" "&B2. Alternatively, you can use the CONCAT function, TEXTJOIN function for skipping blank cells, or Flash Fill to combine names automatically without writing any formulas.
If your spreadsheet keeps first names and last names in two separate columns, you’ve probably run into the problem of needing one clean full-name field instead — for mail merges, reports, or a tidier data entry sheet. This guide shows you how to join those columns without breaking the formatting or losing rows to blank cells. By the end, you’ll be able to pick the right Excel method for your data and turn the result into permanent text you can share safely.
The fastest way to add a first and last name together in Excel is to reference both cells in a formula with a separator in between, such as =A2&" "&B2, which joins the values with a single space. You can also use the CONCAT or TEXTJOIN functions for the same result, or use Flash Fill to generate combined names without writing any formula at all. Once the formula or Flash Fill result looks correct, you fill it down the column and, if you plan to share the sheet, convert it to fixed text so the names stay intact even if the original columns are edited or deleted later.
Add first and last names in Excel with one formula
The core pattern behind every name-joining method in Excel is the same: take one cell, add a separator, then add the second cell. Everything else — CONCAT, TEXTJOIN, Flash Fill — is a variation on this idea.
Full name = First name cell + separator + Last name cell
- First name cell: the worksheet reference containing the first name, such as A2.
- separator: the text placed between names, such as a space (
" ") or a comma followed by a space (", "). - Last name cell: the worksheet reference containing the last name, such as B2.
As a worked example: if A2 contains John and B2 contains Smith, the formula =A2&" "&B2 returns John Smith. The quotation marks around the space are what actually insert the separator — leave them out and Excel will jam the two names together as JohnSmith.
Once the formula works in one row, click the cell, grab the small fill handle in the bottom-right corner, and drag it down through the rest of your data. Excel adjusts the cell references automatically as you go, so row 3 pulls from A3 and B3, row 4 from A4 and B4, and so on. If your list runs to hundreds of rows, double-clicking the fill handle instead of dragging will auto-fill to the last row that has data in the adjacent column, which saves a lot of scrolling.
Combine name columns using Excel formulas and tools
Excel gives you more than one way to reach the same result, and the option you reach for should depend on your version of Excel and how messy your source data is. The ampersand operator is the simplest: =A2&" "&B2 for a space-separated name, or =B3&", "&A3 for a last-name-first format that produces something like Fuller, Andrew. Both examples work in every version of Excel currently in use, which makes the ampersand a safe default when you’re not sure what your reader’s software supports.
CONCATENATE and CONCAT do the same job with function syntax instead of the & symbol. =CONCATENATE(B5," ",D5) combines a first and last name with a space, but it treats every argument as required text, so if a middle-name column is blank it still gets nested into the string. CONCAT is the newer version of the same idea and is the one Microsoft now recommends going forward: CONCATENATE has been replaced by CONCAT in Excel 2016, Excel Mobile, and Excel for the web, though CONCATENATE still works in those versions for compatibility.
TEXTJOIN is worth knowing about even though it’s a bit more to type, because it has one feature the others don’t: it can skip blank cells automatically. =TEXTJOIN(" ",1,B5,D5) joins a first and last name with one space between them, and =TEXTJOIN(" ",1,B5:D5) extends the same idea to a first, middle, and last name range. The 1 in the second argument tells Excel to ignore empty cells, which matters the moment your dataset includes people with no recorded middle name. One caveat: TEXTJOIN is only available in Excel 2019 or later, so it won’t work if you’re distributing a workbook to people on older installations.
Choosing between Excel text functions
CONCAT and TEXTJOIN look similar on the surface, but the difference shows up the moment your data isn’t perfectly clean. CONCAT joins exactly what you give it, with no logic for empty inputs — feed it a blank middle-name cell and you get a stray extra space in the result. TEXTJOIN’s ignore-empty argument handles that case for you, which is why it’s the better default for any dataset where you expect some rows to be incomplete.
For a dataset that will keep changing — new hires added weekly, a class roster updated every term — TEXTJOIN with ignore_empty set to 1 or TRUE is generally the more durable choice, since it won’t need a formula rewrite every time a row’s structure shifts slightly. Reserve the plain ampersand for one-off jobs where the columns are already known to be complete and you just need speed. If reusability inside a shared workbook is the priority, wrapping either approach in a named range or a helper column also makes the formula easier for someone else to audit later.
Creating a full name column from source data
Start by confirming your layout: first names in one column, last names in an adjacent column, and an empty column ready to hold the combined result. Type your chosen formula into the first data row of that empty column, check the output against the two source cells, then fill it down the same way described earlier.
If you’d rather skip formulas altogether, Flash Fill can build the same result by example. Type the full name you want for the first row by hand — for instance, type John Smith next to the row where A2 is John and B2 is Smith — then start typing the second row’s expected result. Excel usually detects the pattern and offers a preview of the rest of the column; press Enter to accept it, or open the Data tab and click Flash Fill if the preview doesn’t appear automatically. Flash Fill is useful for a quick one-time cleanup, but keep in mind it produces static text, not a live formula, so it won’t update if the source names change later.
Fix common name combining errors in Excel
Most name-joining problems in Excel trace back to two causes: hidden extra spaces in the source data, and rows where one of the name fields is simply blank. Both are easy to miss because the result often still looks fine at a glance.
Extra spaces usually come from copied-and-pasted data, imported CSV files, or manual entry where someone hit the spacebar twice. The visible symptom is a full name that shows an odd double gap, like "John Smith" with two spaces between the names, or a name that fails to match in a lookup formula even though it looks identical to the eye. A safer way to check is running =LEN(A2) on a suspect cell and comparing it to the number of visible characters you’d expect; if LEN returns a higher count than what you can count by eye, there’s a hidden space in that cell.
Blank cells cause a different problem. If a middle-name or last-name field is empty and you’re using a plain ampersand or CONCATENATE formula, the result often ends up with an orphaned space or comma sitting where the missing name should be — something like "John " with a trailing space, or ", Smith" with a leading comma.
Prevent extra spaces and missing-name results
Wrapping a formula in TRIM removes leading, trailing, and repeated internal spaces in one step: =TRIM(A2&" "&B2) cleans up the combined result even if A2 or B2 already contains stray whitespace. This is the single most reliable fix for the double-space symptom described above, and it costs nothing in formula complexity.
For blank-cell handling, an IF check lets you skip a separator when a field is empty. A formula like =IF(C2="",A2&" "&B2,A2&" "&C2&" "&B2) only inserts the middle name and its extra space when the middle-name cell actually contains something, rather than leaving a stray gap. TEXTJOIN’s ignore-empty argument does the same job with less typing, so if you’re already on Excel 2019 or later, that’s usually the simpler route for datasets with occasional blank middle names.
As a decision rule: if any row in your dataset could plausibly have a blank first, middle, or last name, don’t rely on a plain ampersand formula — build in either an IF check or use TEXTJOIN with empty cells ignored, because the plain version will silently produce a name with a stray space or comma instead of throwing an error you’d notice.
Convert formula results into permanent values
A formula-based full-name column is still tied to the original first-name and last-name columns behind it. Delete or reorder those source columns and every combined name breaks, usually showing a #REF! error across the whole list. That’s fine while you’re still working on the sheet, but it’s a risk the moment you want to share, sort, or archive the data.
To lock in the result, select the full range of combined-name cells, copy it (Ctrl+C), then right-click the same selection and choose Paste Special, followed by Values. This replaces every formula with its calculated text, so the names remain exactly as they appear even if you later delete the source columns entirely. It’s worth doing this as the very last step, after you’ve already checked for extra spaces and blank-name errors — pasting values locks in whatever the formulas were showing at that moment, mistakes included.
Handle different name formats and column layouts
Not every dataset is a simple two-column first-and-last-name pair. Once a middle name enters the picture, or you need last-name-first formatting for a directory, the same building blocks from earlier sections just get combined differently.
For a first, middle, and last name spread across three columns, TEXTJOIN handles the optional middle name cleanly: =TEXTJOIN(" ",TRUE,A2,B2,C2) places a single space between whichever of the three cells actually contain text and skips over any that are blank. If you’re stuck on an older Excel version without TEXTJOIN, the IF-based approach from the troubleshooting section above is the fallback — it takes more typing, but it produces the same blank-safe result.
Situation: a worksheet has first-name values in A2 and last-name values in B2, and the required output format needs to change from first-name-first to last-name-first.
- Enter
=A2&" "&B2to place the first name before the last name with a space separator. - Enter
=B2&", "&A2to move the last name first and add a comma separator. - Fill the formula down the column to apply the selected name format to the remaining rows.
Result: the same two source cells produce different full-name outputs — "John Smith" from the first formula, "Smith, John" from the second — just by changing where the cell references sit relative to the separator. The separator characters you type become part of the literal output, so a comma placed inside the quotation marks will always show up in the final text exactly where you put it.
This same logic scales past three columns if your data has, say, a title or suffix field as well — just add another reference and separator to the TEXTJOIN argument list, or another & link in an ampersand formula. The formula gets longer, but the underlying pattern of reference-separator-reference doesn’t change.
Select the right name combining method for your data
With several valid ways to reach the same combined name, the deciding factor is usually less about which formula is "correct" and more about how your data behaves and what you need the output for.
Name Combining Methods Compared
| Method | Best use case | Main benefit | Main limitation |
|---|---|---|---|
| Ampersand (&) | Quickly joining two or a few name cells | Simple syntax that works well for basic full-name fields | Requires manual separator handling for each formula |
| CONCAT | Combining name cells with a straightforward modern formula | Clear function-based approach for reusable joins | Does not automatically manage separators between blank cells |
| TEXTJOIN | Joining multiple name parts when some cells may be empty | Can ignore blank cells and apply a chosen separator | Has more arguments to understand than a basic join formula |
Flash Fill sits slightly outside this table because it isn’t a formula at all — it’s a one-time pattern match. That makes it the quickest option for a static list you’ll never need to update again, but the wrong choice for a workbook that receives new rows regularly, since Flash Fill won’t extend itself automatically the way a formula does when you add data below it.
Think about two questions before picking a method. First, does this column need to stay editable if the source names change, or is this a one-time cleanup? A formula preserves that link; Flash Fill and pasted values do not. Second, how likely is it that some rows have missing middle names or other gaps? The more likely that is, the more the ignore-empty behavior in TEXTJOIN pays for its extra typing compared to a plain ampersand join.
Once you’ve settled on a method, build it in one row, check the output against the source cells, fill it down, and — if the sheet is heading somewhere outside your own workbook — paste the results as values before you send it. That last step is the one most guides skip, and it’s the difference between a full-name column that survives being copied into another file and one that breaks the moment the original columns move.
FAQ
Can I combine names in Excel without changing the original columns?
Yes, using formulas like the ampersand operator or functions such as CONCAT and TEXTJOIN allows you to create a new full-name column while leaving your original first and last name source columns completely untouched and intact.
Does Flash Fill work with full name formatting patterns?
Flash Fill can recognize patterns when you manually type the first few combined rows by hand. It automatically populates the remaining rows, though it creates static text rather than a live formula that updates dynamically.
Can Excel combine names from cells on different worksheets?
Excel formulas can reference cells across different worksheets by including the sheet name before the cell reference, such as combining data from Sheet1!A2 and Sheet2!B2 within your join formula.
What happens if a name cell contains extra spaces?
Extra spaces in source cells can result in double gaps or formatting issues in your combined name. Wrapping your joining formula inside a TRIM function removes leading, trailing, and repeated internal spaces automatically.
Can I undo a name combination after pasting values?
Once you paste formula results as values to make them permanent text, the direct link to the original formulas is removed. You can undo this immediately using the standard undo shortcut, but otherwise, you would need to recreate the formula.