To concatenate first and last names in Excel, use =A2&" "&B2 when the first name is in A2 and the last name is in B2. The ampersands join the cell values, and the quoted space puts a space between them; for example, Ava in A2 and Patel in B2 produce Ava Patel.
The simplest formula for joining names
The ampersand (&) is a straightforward way to combine text in Excel. It joins the contents of cells and any text you put in quotation marks. In the example above, A2 supplies the first name, the quoted space supplies a separator, and B2 supplies the surname. The formula returns text; it does not change either source cell.
For example, with Ava in A2 and Patel in B2, =A2&" "&B2 returns Ava Patel. If you omit the quoted space, the result is AvaPatel. If you use a comma and space instead, the result is Ava, Patel. Text separators must be enclosed in straight double quotation marks.
To apply the formula to a list, enter it in the row beside the first pair of names, then copy it down. In Microsoft 365 for Windows, you can drag the fill handle at the lower-right corner of the selected cell, or copy the cell and paste it into the rows below. Excel adjusts relative references as the formula moves: a formula using A2 and B2 becomes one using A3 and B3 on the next row.
Using CONCAT and TEXTJOIN
Excel offers functions for joining text as well as the ampersand operator. With the first name in A2 and last name in B2, =CONCAT(A2," ",B2) also returns Ava Patel. CONCAT can combine cell references and text arguments, but it does not insert separators automatically. You must include the space, comma, or other separator as an argument.
TEXTJOIN is useful when the name has several parts or some cells may be blank. With first, middle, and last names in A2:C2, respectively, =TEXTJOIN(" ",TRUE,A2:C2) joins the values with spaces and ignores empty cells. If A2 contains Ava, B2 is empty, and C2 contains Patel, the result is Ava Patel, with no extra space for the missing middle name.
The second argument, TRUE, tells TEXTJOIN to ignore empty cells. Set it to FALSE if you want empty cells to count as empty text between separators; that can leave repeated spaces or separators. TEXTJOIN is available in current Microsoft 365 Excel. For a simple two-cell name, the ampersand is often easier to read, while TEXTJOIN is convenient for a variable number of parts.
Joining first, middle, and last names
If every row contains first, middle, and last names in A2, B2, and C2, you can join all three with spaces. With those values in A2:C2, =A2&" "&B2&" "&C2 returns Ava Marie Patel when the cells contain Ava, Marie, and Patel. This direct approach is clear when you know every component will be present.
When middle names are optional, two fixed spaces can create an awkward result. If B2 is blank, the same formula returns Ava Patel, with two spaces between the names. Many applications display the extra gap subtly, but it can affect sorting, searching, or later data processing. Use TEXTJOIN to skip blank parts instead:
With first, middle, and last names in A2:C2, =TEXTJOIN(" ",TRUE,A2:C2) returns Ava Patel if the middle-name cell is empty, and Ava Marie Patel if it contains Marie. If a row might have only a last name or only a first name, the same formula also avoids leading or trailing spaces caused by empty cells.
TEXTJOIN treats a cell containing a formula that returns an empty string differently from some visually blank cells: its ignore-empty option is designed to omit empty values. If a result still has unexpected spacing, check whether the source cell contains spaces rather than being truly empty. A cell can look blank while containing a space character.
Adding titles, initials, or punctuation
You can put fixed text directly into a concatenation formula by placing it in quotation marks. With a title in A2 and a full name in B2, =A2&" "&B2 combines them with a space; for example, Dr. in A2 and Ava Patel in B2 return Dr. Ava Patel. The same method can add a comma, a hyphen, or parentheses, but consider whether the punctuation is appropriate for every record.
To create a middle initial, first place the initial in its own cell or extract it from a middle-name value using a separate formula. With first name in A2, middle initial in B2, and last name in C2, =A2&" "&B2&". "&C2 returns Ava M. Patel when B2 contains M. If middle initials are optional, TEXTJOIN alone will not prevent an unwanted period attached to a blank initial; build the punctuation conditionally or store a complete formatted name component in a helper column.
A useful general rule is to treat separators as deliberate text. Use a single space between ordinary name parts, a comma followed by a space for formats such as Patel, Ava, or a hyphen only where the desired display calls for one. Excel does not know which pieces are given names or surnames, so the order in the formula determines the order in the result.
Choosing the right method
For two name cells, the ampersand is usually the simplest choice. CONCAT is a function-based alternative, and TEXTJOIN is especially handy for multiple cells where blanks should be skipped. The older CONCATENATE function may appear in existing workbooks, but Microsoft recommends CONCAT as its replacement. Existing CONCATENATE formulas can still be useful to recognize; you do not need to rewrite a working workbook just because the newer function exists.
- Use
=A2&" "&B2for a simple first-and-last-name combination. - Use CONCAT when you prefer a function and want to specify each piece as an argument.
- Use TEXTJOIN when combining several cells with one separator and you want to ignore blank cells.
- Use a conditional formula or helper column when punctuation or formatting depends on whether a name part is present.
All three methods create a calculated result that can change when the source cells change. If you need a permanent snapshot instead, copy the result cells and use Paste Special > Values to replace formulas with their current displayed values. Keep the original source columns if you may need to edit or reconstruct the names later.
Common problems and how to fix them
- No space between names: Add a quoted space between the references, as in
=A2&" "&B2. Concatenation does not insert punctuation or spaces by itself. - Extra spaces: Check for blank middle-name cells and spaces already present at the beginning or end of source values. TEXTJOIN can skip empty cells, but it does not automatically clean spaces inside nonempty cell values.
- Formula appears as text: Check whether the cell is formatted as Text or whether an apostrophe appears before the equals sign. Change the cell format to General, then re-enter the formula so Excel calculates it.
- Formula displays instead of a result: Confirm that Show Formulas is not enabled. On Windows, Ctrl+` toggles formula display; on Mac, the equivalent shortcut can depend on the keyboard layout, and the Show Formulas command is available on the Formulas tab.
- Unexpected errors or separators: Check that the cell references point to the intended columns. Some regional settings use semicolons rather than commas between function arguments, although the ampersand example has no function-argument separator.
Also distinguish a blank cell from a cell containing a space. To inspect a suspicious value, select the source cell and look in the formula bar; you can also test whether its length is greater than zero. Names imported from another system may contain nonbreaking spaces or other characters that are not obvious on screen, so cleaning imported data may be necessary before combining it.
Formatting a whole column of names
For a normal worksheet range, enter the formula in the first output row and fill it down to match the source records. If the data is an Excel table, adding a formula in a new table column generally fills that calculated column for the table rows. Tables also make headings such as First Name and Last Name easier to identify than bare column letters, and they can extend formulas when new table rows are added.
Before filling a formula through a large list, check a few different records: a complete name, one with a blank middle name, and any unusual punctuation or suffix. Look for accidental spaces and verify that the formula uses the intended name order. If the output is intended for a label, report, or export, consider whether the receiving system expects a particular order or punctuation.
Concatenation does not split names, correct capitalization, or determine which word is a surname. For example, combining two columns is safe only if the data has already been separated consistently. Names may include multiple given names, compound surnames, prefixes, suffixes, or culturally specific ordering. Treat the source fields as data provided, rather than assuming every person follows one naming pattern.
Frequently Asked Questions
What is the formula to combine first and last names in Excel?
With the first name in A2 and last name in B2, use =A2&" "&B2. It joins the values with one space between them.
How do I combine names without extra spaces when a cell is blank?
With name parts in A2:C2, use =TEXTJOIN(" ",TRUE,A2:C2). The TRUE argument tells Excel to ignore empty cells while joining the nonblank parts with spaces.
Can I concatenate names with a comma?
Yes. With first name in A2 and last name in B2, =B2&", "&A2 returns the surname first, followed by a comma and the given name. For Ava in A2 and Patel in B2, the result is Patel, Ava.
Will the combined name update when I change a source cell?
Yes. A formula such as =A2&" "&B2 recalculates when A2 or B2 changes. To keep the current text independent of its source cells, copy the results and paste them as values.
Is CONCAT better than the ampersand?
Neither is inherently better for every case. The ampersand is compact for a few pieces of text, while CONCAT and TEXTJOIN can make longer combinations easier to structure. Choose the method that handles your separators and blank cells clearly.
Related
- Excel MAXIFS: Find the Highest Value for Each Date
- Excel Tabs: How to Find Duplicate Names Across Sheets
- Excel SUM with Multiple Criteria: How to Do It
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula to Pull Out Text Between Two CharactersTo pull text out from between two characters in Excel, use MID with FIND. If A2 contains Order…
- XLOOKUP Excel Column Index: What Replaces It?XLOOKUP does not use a column index number. Instead, you give it the range or array to search…
- Excel Formula to Turn a Vertical List Into a Horizontal RowTo turn a vertical list into a horizontal row in Excel for Microsoft 365, enter =TRANSPOSE(A2:A6) in the…
- Rank in Excel Without Duplicates: Formula and StepsTo give every numeric value a distinct rank in Excel, use RANK.EQ to find its position and COUNTIF…
- INDEX Excel Arguments Explained: Syntax and ExamplesIn Excel, INDEX returns a value or reference at the intersection of a specified row and column in…
- Excel Conditional Formatting Formula for Due Dates ExplainedIn Excel for Microsoft 365 on Windows, select the cells to format, choose Home > Conditional Formatting >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.