How to combine two columns in Excel comes up whenever you want to merge first and last names, join codes with descriptions, or clean up data before analysis. The shortest answer is that you can use &, CONCAT, TEXTJOIN, Flash Fill, or Power Query depending on whether you need a simple one-off merge or a reusable cleanup workflow.
If you are looking for related formulas first, see Excel Concatenate and Excel Concatenate with Delimiter. Those posts cover the broader text-joining toolkit; this guide focuses on the practical two-column use cases people search for most.
Key Takeaways
&is the fastest option for a simple two-column mergeTEXTJOINis best when you need delimiters or want to ignore blanksTEXThelps preserve number and date formatting- Flash Fill is great for one-off cleanup jobs
- Power Query is the better fit for repeatable data cleaning at scale
Stat block — 2026-07-10
Microsoft Support says an Excel worksheet can contain 1,048,576 rows and 16,384 columns.
Source: Microsoft Support, “Excel specifications and limits”
Why that matters: once a worksheet gets that large, formula choice becomes a maintenance issue, not just a convenience issue.
The quickest way to combine two columns in Excel
The quickest way to combine two columns in Excel is to use the ampersand operator, &, or CONCAT if you prefer a named function. For a basic merge, I usually start with =A2&B2; for a readable result, I add a space or comma between the references. That keeps the formula short and easy to copy down a whole column.
When the ampersand operator is enough
If the goal is simply to join two cells into one, & is hard to beat. I use it when I want a result like BlueWidget from two source cells, or Blue Widget when I need a space. The pattern is simple:
=A2&" "&B2That formula combines the text in A2 and B2 with a single space in the middle. If you want a hyphen, a comma, or a slash, just swap the separator. I like this method because it is easy to read and easy to audit later.
When CONCAT is the better fit
CONCAT is better when you want the formula to read like a function instead of an expression. It is especially handy if you are training someone else on the spreadsheet or want a cleaner-looking formula bar. For two columns, it looks like this:
=CONCAT(A2,B2)If you want a separator, you still need to include it as text, so the formula becomes =CONCAT(A2," ",B2). I usually recommend CONCAT for users who prefer formulas that look more consistent across a workbook.
A simple rule of thumb
Use & for the shortest possible merge, and use CONCAT when you want a formula function that is easier to explain. If your combined result must include blanks, spacing rules, or multiple pieces of text, jump to TEXTJOIN instead.
Use TEXTJOIN when you need a delimiter or want to skip blanks
TEXTJOIN is the best choice when you need a separator between values and want Excel to ignore empty cells. It is the cleanest option for combining columns that may have missing data, because it solves two problems at once: formatting and blank handling. That makes it ideal for names, mailing lists, and contact exports.
Why TEXTJOIN is so useful
A two-column merge sounds simple until one of the cells is blank. If you combine A2 and B2 with &, you can end up with awkward double spaces, stray commas, or outputs that look unfinished. TEXTJOIN fixes that by letting you define the delimiter and tell Excel to skip blanks.
=TEXTJOIN(" ",TRUE,A2:B2)That formula joins the range A2:B2 with a space and ignores empty cells. If A2 is blank, the result still looks natural. If both cells contain text, you get one neat combined value. In my experience, that is the version people want when they search for a way to combine two columns in Excel.
Combining names with commas or spaces
For names, I usually use a space. For addresses or filenames, I often choose a comma, dash, or underscore. The syntax stays the same:
=TEXTJOIN(", ",TRUE,A2:B2)This is useful when you are merging first and last name values, or when you need to create a CSV-friendly output. It gives you a clean separator without having to build it manually around each source cell.
When TEXTJOIN beats manual cleanup
I reach for TEXTJOIN when I know the source data is messy. If one out of every ten rows is missing a value, formulas that rely on & can produce extra punctuation or ugly spacing. TEXTJOIN cuts down on those edge cases, so you spend less time cleaning the final column.
Combine first and last name in Excel without making a mess
The cleanest way to combine first and last name in Excel is to use a formula that inserts exactly one space between the two cells. If the data may contain blanks or middle names, TEXTJOIN or a TEXT-wrapped formula is safer. This keeps the output readable, consistent, and ready for mail merges or contact lists.
The standard first-name plus last-name formula
When you have a first name in A2 and a last name in B2, the classic formula is:
=A2&" "&B2That works well when both cells are filled. It is fast, obvious, and easy to fill down the column. If the result should display as a full name in a report, this is usually all you need.
Handling middle names, initials, and blanks
Real-world name data is rarely perfect. Some rows include middle initials, some are blank, and some contain extra spaces. When I need the result to survive imperfect input, I use a more defensive formula:
=TRIM(TEXTJOIN(" ",TRUE,A2:C2))This version combines first, middle, and last name across three columns, skips blanks, and trims extra spacing. It is a small upgrade, but it saves a lot of cleanup when your list is large or inconsistent.
A practical naming workflow
My usual workflow is to create a new helper column called something like Full Name, enter the formula in the first row, and fill it down. Then I review a few rows to make sure the spacing looks correct. If the output is going into a mail merge or CRM export, I will often copy and paste values after verification so the combined names are no longer formula-driven.
Keep numbers, dates, and leading zeros intact when you combine columns
If your source data includes numbers or dates, use TEXT before you combine the columns. Excel stores dates and many numeric formats in ways that can look strange when they are joined into plain text. Wrapping the value in TEXT preserves the appearance you actually want.
Why plain concatenation can break formatting
A common mistake is combining text with a date or code and assuming Excel will keep the original display format. Instead, Excel can convert the value to a serial number or strip leading zeros. That is why a formula that looks fine at first glance can produce a result that is technically correct but visually wrong.
=A2&" "&B2If B2 is a date, that formula may display the date as a number. If B2 is a code like 0007, the leading zeros can disappear. I avoid that by formatting the source value inside the formula itself.
Use TEXT for dates and codes
For dates, I use:
=A2&" "&TEXT(B2,"mm/dd/yyyy")For leading zeros, I use a fixed-width text format:
=A2&" "&TEXT(B2,"000000")Those formulas make the output much safer for reports, labels, and exported files. They also make it easier to combine columns without reformatting the entire workbook.
When numbers should stay numbers
If the combined result still needs to be calculated later, think carefully before converting everything to text. Once a formula turns a number into text, Excel will not treat it like a number anymore. In that case, I keep the original source columns intact and add a separate combined column for display only.
Use Flash Fill or Power Query for repeatable cleanup
Flash Fill is the easiest no-formula option for one-off tasks, while Power Query is the stronger choice for repeatable data cleaning. If you just need to combine two columns a single time, Flash Fill is fast. If you need to combine columns every week, Power Query usually pays off.
Flash Fill for a quick one-time job
Flash Fill works best when your pattern is obvious. For example, if A contains first names and B contains last names, type the desired full name in the adjacent column, then use Flash Fill to complete the pattern. In many cases, Excel recognizes the structure after just 1 or 2 examples.
I like Flash Fill for quick cleanup because it does not require a formula or a long setup. It is especially helpful when the data is already close to the final format and you only need a small transformation.
Power Query for repeatable merges
Power Query is my favorite option for recurring data preparation. In Power Query, I can select the two columns, use Merge Columns, pick a delimiter, and load the result back into Excel. The transformation stays repeatable, so the next time new data arrives, I can refresh instead of rebuilding the workflow.
That is why Power Query is so useful for data cleaning jobs that involve merge columns or join columns over and over again. It turns a manual task into a reliable process.
When to move beyond formulas
I switch away from formulas when the workbook becomes hard to audit or when the same cleanup needs to happen again and again. If your combined column is part of a larger import pipeline, Power Query is usually the most maintainable answer.
Common mistakes when combining two columns in Excel
The most common mistakes are missing separators, broken date formatting, accidental double spaces, and formulas that are copied without checking the output. If you avoid those four problems, your combined column will look clean and stay usable. Most issues are easy to fix once you know where to look.
Forgetting the separator
People often write =A2&B2 and then wonder why the result looks compressed. That is fine for IDs or codes, but not for names or phrases. If the result needs to be readable, add a space, comma, or other separator on purpose.
Not protecting the format of dates and numbers
If a cell contains a date, code, or decimal value, use TEXT before concatenating it. This is the single easiest way to prevent strange-looking output.
Leaving formula results unreviewed
I always scan a few rows after copying a formula down. That quick check catches blanks, punctuation errors, and weird formatting before the worksheet gets shared. It takes less than a minute and saves a lot of cleanup later.
Related reading
If you want the broader text-joining toolkit, start with Excel Concatenate and Excel Concatenate with Delimiter. Those guides go deeper on CONCAT, TEXTJOIN, and the ampersand operator, while this article focuses on the practical job of combining two columns in Excel.
Frequently Asked Questions
What is the fastest formula for combining two columns in Excel?
For a simple merge, I use =A2&" "&B2. It only needs 2 references and 1 separator, so it is the fastest thing to type when you just want a readable combined value. If the data may contain blanks, I switch to TEXTJOIN instead.
How do I combine two columns and keep blanks from showing up?
I use TEXTJOIN with TRUE for the ignore-empty setting. The function is built for this job, and its 3 core parts — delimiter, ignore_empty, and text — make it easier to keep the output clean when one of the source cells is blank.
When should I use Power Query instead of a formula?
If I am cleaning 1,000 or more rows, or if I expect to repeat the process every week, Power Query is usually the better choice. A formula is fine for a quick worksheet, but Power Query gives me a reusable transformation that can be refreshed in just a few clicks.
How do I combine numbers or codes without losing leading zeros?
I wrap the value in TEXT before combining it. A 6-digit code can stay in 000000 format, and that same pattern works for dates if I want to keep a consistent display such as mm/dd/yyyy. That protects the presentation of the final combined column.
Can I combine columns without changing the original data?
Yes. I create a new helper column, enter the formula there, and leave the source columns untouched. That approach is safer because the original values remain available for future analysis, and I can always copy the combined results as values later if needed.
