How to combine columns manually in Excel
Excel can join values from several cells, but only through formulas or Flash Fill. The well-known Merge & Center button is not one of the ways: it merges the cells into one box and throws away everything except the upper-left value.
The & operator
- Insert an empty column where you want the result.
- Enter
=A2&" "&B2to join A2 and B2 with a space, and fill it down. - For three columns, keep chaining:
=A2&" "&B2&" "&C2.
The weakness shows with blank cells. If the middle name in B2 is empty, you get two spaces in a row.
CONCAT, CONCATENATE and TEXTJOIN
=CONCATENATE(A2," ",B2) works in every version and does the same as the & operator. CONCAT, available in Excel 2019 and Microsoft 365, also accepts a range, but it has no separator, so =CONCAT(A2:C2) runs the values together.
TEXTJOIN solves both problems: =TEXTJOIN(" ",TRUE,A2:C2) joins the range with a space and the TRUE tells Excel to skip empty cells. It is the best formula option, but it needs Excel 2019 or Microsoft 365 and joins the cells in the order they sit on the sheet, so a “Last, First” result needs the cells listed one by one.
Dates inside formulas
A formula such as =A2&" "&B2 turns a date in B2 into its serial number, so 4 October 2026 appears as 46299. Wrap the date in TEXT to control how it reads: =A2&" "&TEXT(B2,"dd-mm-yyyy").
Keep the values before deleting the originals
Formula results depend on their source cells. If you delete the First name and Last name columns, every formula becomes #REF!. Copy the new column, use Home › Paste › Paste Values over itself, and only then delete the source columns.
Flash Fill and Power Query
Typing “Priya Shah” next to the first row and pressing Ctrl+E fills the pattern down, which suits short, tidy lists. In Power Query, select the columns and choose Transform › Merge Columns, picking a separator and a new column name. Power Query is the sturdier choice for a report you rebuild every month.
Where this tool helps
Full names for mail merges. Customer lists often keep first, middle and last name apart, while letters, certificates and email greetings need one Full name field. Skipping empty middle names keeps the spacing right.
Addresses for courier labels. Shipping portals and label templates often ask for a single address line. Combine Street, City and State with a comma so each label reads “12 MG Road, Pune, Maharashtra”.
Lookup and matching keys. When no single column identifies a record, join two that do, such as invoice number and date, or customer code and branch. The combined key works with VLOOKUP, XLOOKUP and Remove duplicates.
SKUs built from parts. Category, size and colour codes joined with “Other text” set to a single dash give identifiers like “TS-M-BLK”.
Phone numbers with their country code. Forms that collect the dialling code and the number in separate boxes produce two columns, “+91” and “9876543210”. Joining them with nothing in between gives a single field that WhatsApp tools and SMS platforms accept, and the number part is joined exactly as it reads in the cell.
How the tool handles the details
- Order is yours to choose. The values are joined in the order of the Order list, not the order of the sheet, so “Shah, Priya” is as easy as “Priya Shah”.
- Values are trimmed before joining, so a stray space at the end of a first name does not become a double space.
- The result is plain text with no formulas, which means you can safely delete or rearrange other columns afterwards.
- The header row is respected. The new column gets the name you type, or the chosen column names joined with “ + “.
- A short summary confirms the change, for example “Combined First name, Middle name and Last name into “Full name” in 5 rows, separated by a space.”
At least two columns must be ticked. The download keeps the format you opened, so an Excel workbook stays an Excel workbook and a CSV stays a CSV.
Examples
| Values (in order) | Put between | Result |
|---|---|---|
| Priya · (blank) · Shah | A space | Priya Shah |
| Rahul · Kumar · Mehta | A space | Rahul Kumar Mehta |
| Desai · Anita | A comma | Desai, Anita |
| TS · M · BLK | A dash | TS - M - BLK |
| TS · M · BLK | Other text: - | TS-M-BLK |
The third row uses the Order list to put Last name before First name. The built-in dash adds a space on each side, so for compact codes choose “Other text” and type a single “-”.
Tidy first, then combine
Clean the source columns before joining them. Removing extra spaces and fixing capital letters first means the combined values are consistent, which matters most when they become keys for matching or removing duplicates.