No—Excel’s CONCAT, CONCATENATE, TEXTJOIN, and the & operator join cell contents, but they do not carry the source cells’ formatting into the result. You can format the finished cell as a whole, control how dates and numbers appear with TEXT, or use static text and manual or VBA-based rich-text formatting when different parts need different styles.
What Concatenation Does in Excel
Concatenation means joining text or values into one text string. In Microsoft Excel for Microsoft 365 on Windows, the & operator is a straightforward way to join a few cells, while CONCAT and TEXTJOIN are useful for ranges or lists. CONCATENATE is an older function that remains available for compatibility, but Microsoft recommends CONCAT for new formulas.
For a simple example, with a first name in A2 and a last name in B2, enter =A2&" "&B2 in another cell. If A2 contains Maya and B2 contains Chen, the result is Maya Chen. The formula joins the two values and inserts a space; it does not copy the font, fill color, border, or other formatting from either source cell.
A formula result is a value displayed in its destination cell. Excel can apply formatting to that destination—such as a font, fill, border, alignment, or number format—but the result does not inherit each input cell’s appearance. This distinction matters because “formatting” can mean either the appearance of the whole cell or special formatting applied to only some characters.
Why Source Formatting Does Not Carry Over
Excel formulas calculate values; they do not combine the visual styles of their referenced cells. If A2 is red and bold and B2 is blue and italic, a formula that joins A2 and B2 returns one string in the destination cell. You can style that entire output in one way, but the formula does not remember which characters came from which source cell.
There are two related kinds of formatting to keep separate:
- Cell-level formatting affects the whole cell: font, fill, borders, alignment, or a number format.
- Character-level formatting, also called rich-text formatting, affects only part of a text value, such as making one word bold or coloring a phrase.
Even when a source cell looks like a date or a currency amount, a formula joining it to text works with the value, not a copy of its displayed appearance. A date is stored as a number, for example, so explicitly formatting it as text is often necessary before joining it to a label.
Control Dates, Numbers, and Leading Zeros
When a joined result includes a date, use TEXT to specify the display pattern. With a date in B2 and an event name in A2, where B2 contains November 3, 2026, enter =A2&" — "&TEXT(B2,"mmmm d, yyyy"). If A2 contains Project review, the result is Project review — November 3, 2026. The TEXT function converts the date to text in the requested pattern before the formula joins the pieces.
Use a similar approach for amounts. With an item name in A2 and a numeric price of 12.5 in B2, enter =A2&": $"&TEXT(B2,"0.00"). The result is Item: $12.50. The dollar sign is written in the formula, and the format pattern ensures two decimal places. If you need thousands separators, a pattern such as "#,##0.00" can display them according to the applicable regional settings.
Leading zeros need special attention. If a cell contains the number 27 but is merely formatted to display 0027, concatenation may use the underlying number rather than the padded display. To create a four-digit text value, with the number in A2, use =TEXT(A2,"0000"). If A2 contains 27, the result is the text 0027. If the identifier is important as text, storing it as text from the start can also prevent Excel from treating it as a number.
For a range of values, with A2:C2 containing North, blank, and Branch, enter =TEXTJOIN(" - ",TRUE,A2:C2). The result is North – Branch: TEXTJOIN inserts the chosen separator and, because its second argument is TRUE, ignores empty cells. Without that setting, blank cells can leave repeated separators. TEXTJOIN does not preserve formatting either; it only offers convenient control over separators and empty values.
Format the Finished Cell as a Whole
If one consistent style is all you need, calculate the result and format the destination cell normally. Select the output cell and use the font, fill, border, alignment, or other controls on the Home tab. You can also use Home > Format Painter to copy an entire cell’s appearance to the result. This changes how the output cell looks, not the formatting of individual source-derived words.
Remember that a formula returning joined text is text, even if part of the string looks like a number or date. Applying a currency or date number format to the result cell will not turn text within the string into a formatted numeric value. Set the appearance of those pieces inside the formula with TEXT, then apply any desired overall cell styling to the result.
For a report that must retain its appearance but no longer needs to update, you can copy the formula result and use Paste Special > Values to replace the formula with fixed text. That makes the result static. You can then apply character-level styling to selected portions if your Excel version and editing workflow allow it. Keep a copy of the formula or original data first if future updates may be needed.
When You Need Different Formatting Within the Result
A formula cannot tell Excel to make the first source cell’s text bold and the second source cell’s text italic. For a one-off result, the practical method is to create the combined text, convert it to a fixed value if necessary, and select the relevant characters in the formula bar or cell for manual formatting. The exact editing experience can vary with the cell and Excel version, and changes to the source formula can replace the result, so keep the output static if its rich-text styling must remain stable.
For repeated work, VBA can be written to assemble the text and copy selected character attributes—such as bold, italic, font name, size, or color—character by character. That is a custom solution, not a built-in concatenate option. It needs rules for separators, blank cells, mixed formatting, and later changes to the source range. Test any macro on a copy of the workbook; macros cannot be undone with Ctrl+Z. A macro that only applies a cell’s overall font will not preserve different styles within a source cell.
If the goal is only to keep the source cells visually distinct, consider leaving the data in separate columns and improving the layout instead. For example, a report can display a name in one column and a department in the next, with consistent alignment and borders. That often makes the information easier to edit and filter than a single rich-text string.
Common Misconceptions and Mistakes
Merge & Center is not concatenation. Merging cells combines the cell area, not the values. When multiple selected cells contain data, Excel warns that the merge keeps only the upper-left cell’s content and discards the other contents. Use a formula or another data-combining method when every value must remain.
Paste Special > Formats does not transfer separate formatting into a formula string. It copies cell-level formatting to a destination cell. It cannot map the font or color of each source value onto the corresponding characters in a joined result.
A displayed value may not be the stored value. Dates, percentages, and numbers with custom formats can look different from their underlying values. If a result shows an unexpected date serial, many decimal places, or missing zeros, use TEXT with an appropriate pattern or store an identifier as text.
Concatenation does not insert separators automatically. CONCAT joins items without adding spaces or punctuation. Add the separators explicitly in the formula, or choose a delimiter with TEXTJOIN. Check the result for extra spaces when some inputs are blank.
Choosing the Right Method
Choose based on whether the output needs to remain dynamic and what kind of formatting matters:
- Dynamic text, same appearance throughout: use &, CONCAT, or TEXTJOIN, then format the destination cell as a whole.
- Dynamic text containing dates or formatted numbers: use TEXT for the pieces that need a defined display pattern, then join them.
- One-time text with differently styled words: create the string, make it static if appropriate, and apply character formatting manually.
- Repeated rich-text output: consider a carefully designed VBA solution, with a tested rule for how source formatting is mapped to output characters.
- Data that needs sorting, filtering, or later calculation: keep the original values in separate cells and combine them only for display when needed.
Power Query can combine columns as part of a repeatable data transformation, but it is not a tool for preserving source-cell fonts, colors, or rich-text styling in a joined result. Like formulas, it is useful for shaping values; it should not be mistaken for a visual-formatting merge.
Frequently Asked Questions
Can CONCAT preserve bold or colored text from the source cells?
No. CONCAT joins values as text and does not carry over character-level bolding, font colors, or other rich-text styles. Format the completed text manually after making it static, or use custom VBA for a repeatable workflow that copies the required character attributes.
How do I concatenate cells with a space or comma between them?
Insert the separator explicitly with the & operator, or use TEXTJOIN to apply one delimiter across a range. For example, TEXTJOIN can use a comma and space as its delimiter and can be set to ignore empty cells.
Why does my concatenated date show as a number?
Excel stores dates as serial numbers. When the formula converts a date into a text string, the source cell’s date format is not automatically included. Wrap the date reference in TEXT and specify the pattern you want, such as a month name and four-digit year.
Can I keep the formula and manually format only part of its result?
Formula-generated text is not a reliable way to maintain source-based rich-text formatting. Character formatting may be lost or become unsuitable when the formula recalculates. For a stable, manually styled result, replace the formula with its value first, or use a macro designed to reapply the styling after updates.
Does Merge & Center combine the text in selected cells?
No. It merges the selected cell area and retains the upper-left cell’s content; other contents can be discarded after Excel’s warning. Use concatenation when you need to join the values themselves.
Related
- Capitalize Shortcut in Excel: Fast Ways to Change Case
- Insert Image in Excel: Steps, Cell Options, and Tips
- Cannot Find Data Validation in Excel? Here’s Where
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Merge Cells Per Row: The Right Way to Do ItTo merge cells separately across each row in Excel for Microsoft 365 on Windows, select the full range…
- Unique Excel Formula With Multiple Criteria: How It WorksTo return distinct values that meet multiple conditions in Excel for Microsoft 365, combine UNIQUE with FILTER. With…
- How to Find the Mode in Excel: Formulas and ExamplesTo find the most frequently occurring number in Excel, enter =MODE.SNGL(A2:A11) in an empty cell, replacing A2:A11 with…
- Excel IFS in Multiple Cells: Apply Logic Across RangesTo use IFS in multiple cells, write the formula for the first row, then copy or fill it…
- Excel Data Validation Lists Based on FormulasYes. In Excel for Microsoft 365 on Windows, you can base a Data Validation list on formula-generated choices.…
- Excel Filter Multiple Criteria in One Column: How It WorksTo filter one Excel column for several allowed values, select the column’s filter arrow and check each value…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.