To join text from three columns in Excel, enter =A2&" "&B2&" "&C2 in a new column, replacing the spaces between quotation marks with the separator you want. For example, if A2 contains Maya, B2 contains Chen, and C2 contains Seattle, the result is Maya Chen Seattle. You can also use CONCAT or TEXTJOIN, especially when you want to handle blank cells more conveniently.
Choose a formula for your three columns
Excel does not combine separate cell values into one text string automatically; you create a formula in a fourth column. The ampersand operator (&) is the most direct choice for exactly three cells. It works in current Excel versions and lets you see precisely where spaces, commas, or other characters will appear.
With the first, middle, and last parts of a name in A2, B2, and C2, this formula joins them with spaces. The layout assumes A2 contains Maya, B2 contains Lin, and C2 contains Chen; the result is Maya Lin Chen:
=A2&" "&B2&" "&C2
If the columns contain a city, state, and postal code, you might use a comma after the city and a space before the postal code. With A2 containing Portland, B2 containing Oregon, and C2 containing 97205, the result is Portland, Oregon 97205:
=A2&", "&B2&" "&C2
Notice that each separator is enclosed in straight double quotation marks. Text typed directly into a formula needs those quotation marks; cell references do not. A missing space inside a separator can make otherwise correct values run together.
Enter the formula and copy it down
To combine the values for every record, put the formula in the first row of your output column, then copy it down alongside the source data. For example, if the source data starts in row 2 and column D is empty:
- Click D2, or the first empty cell in your chosen output column.
- Type the formula using the references for that row, such as
=A2&" "&B2&" "&C2, and press Enter. - Select D2 again. Drag its small fill handle at the lower-right corner down to the last data row. You can also double-click the fill handle when the neighboring column has a continuous list of records.
- Check a few results, including rows with longer values or blank cells, to confirm that the separator and column order are right.
Excel adjusts relative references as the formula is filled down: the next row uses A3, B3, and C3, then A4, B4, and C4. The formula does not alter the original cells. If your data is formatted as an Excel table, entering a formula in the output column will generally fill the calculated column for the table automatically.
Use CONCAT or TEXTJOIN
CONCAT is a function-based way to join text. It can be useful if you prefer to see a named function rather than the ampersand operator, but it does not insert separators for you. With A2 containing Maya, B2 containing Chen, and C2 containing Seattle, this formula returns Maya Chen Seattle:
=CONCAT(A2," ",B2," ",C2)
TEXTJOIN is designed for joining values with a repeated delimiter. Its first argument is the separator, its second tells Excel whether to ignore empty cells, and the remaining argument or arguments specify what to join. With the three source values in A2:C2, this formula joins nonempty cells with a space:
=TEXTJOIN(" ",TRUE,A2:C2)
If A2 is Maya, B2 is blank, and C2 is Chen, the result is Maya Chen because TRUE tells TEXTJOIN to ignore empty cells. TEXTJOIN is available in Microsoft 365 and in Excel 2019 and later. In a version that does not include it, the ampersand formula is a straightforward alternative.
For a comma-and-space delimiter, use the same range with a different first argument. With Portland, a blank cell, and Oregon in A2:C2, the result is Portland, Oregon:
=TEXTJOIN(", ",TRUE,A2:C2)
Decide how blank cells should appear
Blank cells are a common reason to choose TEXTJOIN instead of a basic formula. With the ampersand version, Excel still adds every separator you typed, even when one of the referenced cells is empty. If B2 is blank, =A2&" "&B2&" "&C2 can leave extra spacing between the values. Excel may display consecutive spaces in a way that is hard to notice, but they remain part of the resulting text.
When you want Excel to skip empty cells and use one separator only between values that exist, use TEXTJOIN with TRUE. With A2:C2 containing Portland, a blank, and Oregon, =TEXTJOIN(", ",TRUE,A2:C2) returns Portland, Oregon, without an extra comma or space for the blank cell.
There is an important distinction between a genuinely empty cell and a cell that looks blank. A formula returning an empty string, such as ="", is treated as empty by TEXTJOIN when its ignore-empty argument is TRUE. A cell containing one or more spaces is not empty, however, so those spaces may still affect the result. If the source data contains stray spaces, clean it before joining or use a cleanup formula.
Sometimes an empty position is meaningful and you want to keep its separator. In that case, set TEXTJOIN’s second argument to FALSE. With A2:C2 containing Portland, a blank, and Oregon, =TEXTJOIN(", ",FALSE,A2:C2) returns Portland, , Oregon. That may be useful when position matters, but it is usually not the desired presentation for a name or address.
Preserve dates, numbers, and clean spacing
When Excel joins a number or date with text, the displayed result might not retain the source cell’s number format. A date stored as a serial number, for example, can appear as a number rather than as a date. Format the value explicitly with TEXT when the joined result needs a particular appearance.
Assume A2 contains Maya, B2 contains a real Excel date representing January 15, 2026, and C2 contains Active. This formula formats the date as an abbreviated month, day, and year; its result is Maya Jan 15, 2026 Active:
=A2&" "&TEXT(B2,"mmm d, yyyy")&" "&C2
The format code controls the date’s appearance, not the underlying date value. For example, a different format code can show a numeric month and day. If a value is already stored as text rather than as a real Excel date, TEXT may not treat it as a date in the same way, so check the source data when the output is unexpected.
To remove repeated ordinary spaces from joined text, TRIM can help. With A2:C2 containing values that may have extra leading, trailing, or repeated spaces, this formula returns the three values joined with single spaces:
=TRIM(A2&" "&B2&" "&C2)
TRIM is useful for routine spacing cleanup, but it does not remove every unusual whitespace character. Data copied from websites or other systems can contain nonbreaking spaces that look like ordinary spaces. If cleanup still seems incomplete, inspect the source values rather than assuming the join formula is at fault.
Choose a separator that fits the result
The separator is part of the output, so choose one that makes the combined value readable and suitable for its next use. A space often works for names; comma-space works for locations; a hyphen or slash can distinguish codes. For example, with a product code split across A2:C2, a hyphen separator produces a recognizable label:
=TEXTJOIN("-",TRUE,A2:C2)
With A2:C2 containing AB, 17, and Blue, the result is AB-17-Blue. If the joined value will be imported into another system or split apart later, confirm that your chosen separator cannot be confused with characters already present in the source fields. Joining is not the same as creating a structured data format: a comma inside a source value may need special handling if the output is intended to be a CSV file.
You can also put each value on its own line within one cell. With A2:C2 containing Portland, Oregon, and 97205, this formula separates the entries with line breaks:
=TEXTJOIN(CHAR(10),TRUE,A2:C2)
Turn on Wrap Text for the output cell so the line breaks are visible within the worksheet. The joined cell still contains one value, not three separate cells, and copying it elsewhere may require a destination that supports line breaks.
Common problems and practical checks
- Values run together: Add a separator inside quotation marks, such as
" "or", ". Excel does not supply spaces automatically. - There is an extra separator: Use TEXTJOIN with TRUE if blank cells should be skipped. Check for cells containing spaces, which are not truly empty.
- A date or number looks different: Use TEXT with an appropriate format code for the value that needs formatting.
- The formula appears as text: Check whether the cell is formatted as Text or whether the entry has a leading apostrophe. Set the cell to General, then re-enter the formula.
- The formula shows an error: Confirm that quotation marks and parentheses are balanced and that each cell reference points to the intended row. If your regional Excel settings use semicolons as list separators, the argument separators in function formulas may need to follow those settings.
Before copying results into another application, decide whether you need live formulas or fixed text. A formula updates when its source cells change. If you need a snapshot, copy the output cells and use Paste Special > Values to replace the formulas with their current results. Keep the source columns if you may need to revise the combined information later.
When a formula is not the best approach
For a one-time combination, a worksheet formula is usually simple and easy to review. If the source data is imported repeatedly and needs the same cleanup each time, Power Query may be more appropriate. In Excel for Microsoft 365 on Windows, open the data in Power Query through Data > From Table/Range, select the columns, and use the merge-columns command in the Power Query Editor. Choose a separator and load the result back to the worksheet. The exact available import route can vary with the source and workbook.
Power Query is useful when joining is one step in a repeatable import-and-clean process, but it is more setup than most people need for three cells in an existing worksheet. A formula is also easier to adjust row by row. Avoid replacing source data with a combined column unless you are sure you no longer need the separate fields; once only the joined text remains, it can be difficult to separate reliably, especially if the source values contain the same delimiter.
These formulas also work in Excel for the web, although the ribbon and fill behavior may look different from the Windows desktop app. Excel for Mac supports the same basic joining formulas. The main formula examples here use commas between function arguments as requested; some regional settings use semicolons instead.
Frequently Asked Questions
How do I combine three columns in Excel with a space?
With the values in A2, B2, and C2, enter =A2&" "&B2&" "&C2 in another cell. Fill the formula down to combine the remaining rows.
Can I join three columns and skip blank cells?
Yes. With the three values in A2:C2, use =TEXTJOIN(" ",TRUE,A2:C2). TRUE tells TEXTJOIN to ignore empty cells, while the quoted space is the separator between values.
What is the difference between CONCAT and TEXTJOIN?
CONCAT joins the items you specify but does not add a delimiter automatically. TEXTJOIN accepts a delimiter and can optionally skip empty cells, making it convenient for lists with possible blanks.
Can I combine columns without changing the original data?
Yes. Put the formula in an unused column. It creates a separate result and leaves the three source columns unchanged. The result updates if those source values change.
How do I keep a date readable when joining it with text?
Wrap the date cell in TEXT and supply a format code, such as TEXT(B2,"mmm d, yyyy"). This controls how the date appears in the combined result instead of relying on the cell’s display format.
Related
- Import Excel Data and Export to CSV: A Practical Guide
- How to Import CSV to Excel: Steps and Common Fixes
- How to Import CSV to an Existing Excel File
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Rank Low to High in Excel: Formulas, Sorting, and TipsYes. To assign ranks with the lowest value as rank 1, use Excel’s RANK.EQ function with its order…
- C++ String Built-In Functions and How to Use ThemC++ does not have a special set of built-in functions devoted to strings: its everyday string type is…
- Postgres Function Return Table? ExplainedYes, a PostgreSQL function can return a table by using RETURNS TABLE (...) in its definition, which lets…
- Convert Dates to Text in Excel: Formulas and MethodsIf the dates are real Excel dates in A2:A1000, enter =TEXT(A2,"mmmm d, yyyy") in B2 and fill it…
- Excel Concatenate Formula Examples for Text and CellsWith a first name in A2 and a last name in B2, join them with a space using…
- Excel EOMONTH Formula: Find the Last Day of a MonthUse Excel’s EOMONTH function to return the last day of a month: enter =EOMONTH(start_date, months), replacing the arguments…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.