No. Excel’s CONCATENATE, CONCAT, and TEXTJOIN functions combine values into text, but they do not preserve rich-text styling such as bolding or color applied to only part of a source cell. To keep number details such as dates, currency, or percentages readable, wrap those values in TEXT; to style only part of the finished text, use a different method.
What “keep formatting” means in Excel
The word formatting can refer to two different things, and separating them explains most surprises. A cell can have a value format, such as a date or currency display, and it can also have character-level styling, such as making one word bold inside a sentence. Concatenation handles neither by copying the source cell’s appearance into the result.
For example, a source cell may contain the numeric value 45200 and use a date number format so it displays as a calendar date. A formula that joins that value to a label may use its underlying number rather than the date appearance the cell shows on the worksheet. Likewise, if a source cell contains “Priority” in red bold type, joining it to other text does not make those same letters red and bold in the result.
The output is a text value in one destination cell. The destination cell can have its own font, size, fill, and alignment, but those settings apply to the whole cell’s displayed text. They do not retain separate styles from each source.
How CONCATENATE, CONCAT, and TEXTJOIN work
CONCATENATE is the older function name. CONCAT is its newer replacement, and TEXTJOIN adds a delimiter and an option to skip empty cells. All three combine content, not rich-text appearance. The ampersand operator (&) is another common way to join values, with the same formatting limitation.
With a first name in A2 and a last name in B2, use this formula to join them with a space:
=CONCAT(A2," ",B2)
If A2 contains Maya and B2 contains Chen, the result is “Maya Chen.” It is a single text result; the formula does not copy a different font, color, or emphasis from either input. With the same cells, this older equivalent also joins the names:
=A2&" "&B2
With values in A2:C2, this formula joins the nonempty cells with comma-space separators and skips blanks:
=TEXTJOIN(", ",TRUE,A2:C2)
These formulas are available in current Microsoft 365 Excel. CONCAT and TEXTJOIN are also available in many older supported Excel editions, while CONCATENATE remains useful in older workbooks. Function availability can depend on the Excel release. In English-language Excel, the formulas below use commas between arguments; some regional settings use semicolons instead.
Preserve dates, currency, and percentages with TEXT
When the issue is how a number appears inside a joined sentence, TEXT is usually the right tool. It converts a numeric value to text using a format code you specify. This preserves the intended display in the formula’s result, rather than copying the source cell’s formatting. The format code is part of the formula, so choose one that matches the report or message you are building.
With a name in A2 and an Excel date in B2 representing March 8, 2026, this formula produces “Maya — March 8, 2026”:
=CONCAT(A2," — ",TEXT(B2,"mmmm d, yyyy"))
The date format code uses the full month name, day number, and four-digit year. Change it to a pattern such as “yyyy-mm-dd” if that is the date style your audience needs. If you join the date directly without TEXT, Excel may show its underlying serial number instead of the date display you see in B2.
With an amount of 1234.5 in A2, this formula returns “Invoice total: $1,234.50”:
=CONCAT("Invoice total: ",TEXT(A2,"$#,##0.00"))
The dollar sign and two decimal places are specified in the format code. Adjust the currency symbol and pattern for the currency and conventions you actually need. TEXT changes the value into text; it does not change the original number in A2.
With a decimal percentage of 0.085 in B2, this formula returns “Rate: 8.5%”:
=CONCAT("Rate: ",TEXT(B2,"0.0%"))
The percent sign in the format code tells Excel to display the decimal as a percentage, while “0.0” requests one decimal place. This matters because joining a decimal directly could show 0.085 rather than the intended 8.5%.
Keep leading zeros and other identifier details
IDs, postal codes, and account references often look numeric but are identifiers rather than quantities. If Excel stores an identifier as a number, it may remove leading zeros from the stored value. A custom number format can make a value look padded in its original cell, but joining it may not preserve that appearance. Use TEXT to supply a fixed-width display when the underlying value is numeric.
With the number 274 in A2 and a requirement for five digits, this formula returns “00274”:
=TEXT(A2,"00000")
If the identifier is already stored as text, its leading zeros are part of the text and can be joined as entered. For future imports or data entry, storing identifiers as text is often safer than treating them as numbers. This also avoids Excel interpreting long codes as scientific notation or changing digits in very long numeric entries. Use the approach that matches how the source data is stored, and check a few outputs before filling a formula down a large list.
Apply formatting to the entire result cell
Although a joining formula does not carry source styles, you can format the destination cell as a whole. Select the formula cell and use the Home tab to set its font, font size, font color, bold or italic style, alignment, or fill. In Microsoft 365 Excel for Windows, these controls are on the Home tab. Excel for Mac has corresponding controls on its Home tab, though the ribbon layout can differ slightly.
Whole-cell formatting is useful when every generated label should look consistent. For instance, you can make all formula-generated customer names blue, bold, or centered. The formula remains responsible for the words and separators; the destination cell’s formatting controls how the entire result looks.
Changing the destination cell’s number format is not a substitute for TEXT when the formula returns a text string. A date format applied to a sentence such as “Due: ” plus a date cannot selectively turn the date portion into a date display. Format the date inside the formula with TEXT, then use cell formatting for the appearance of the whole sentence.
When only part of the result must be bold or colored
Excel formulas return a value, not a collection of independently styled text runs. There is no standard CONCAT option that says “make the first source red” or “bold only the amount.” Formatting the formula cell applies to all its displayed characters. This is a limitation of formula-generated text, not a setting that can be switched on in CONCATENATE.
If the result does not need to update automatically, one practical option is to create the text with a formula, copy the result, and use Paste Special > Values to replace the formula with a fixed text value. You can then select characters in the cell’s formula bar or while editing the cell and apply character formatting where Excel permits it. Because the formula has been replaced, later changes to its source cells will not update that text; keep the formula or a source-data copy if you need to revise it.
For a frequently refreshed report, consider whether separate cells can achieve the desired design. Put the label and value in adjacent cells, format them independently, and use borders or alignment to make them read as one line. If a single cell with mixed character styles is essential, a desktop Excel VBA procedure can write a text value and apply formatting to selected characters. That approach requires maintenance and may need to be rerun when the source changes. VBA macros cannot run in Excel for the web, and macros cannot be undone with Ctrl+Z, so save a copy of the workbook before running one.
Choose the right method for the job
Use the simplest method that meets the actual requirement. Before building a long formula, decide whether you need to preserve a readable value, a whole-cell appearance, or mixed styling within one sentence. Those are different jobs and have different solutions.
- Join plain text: use CONCAT, TEXTJOIN, or the ampersand operator.
- Display a date, amount, or percentage correctly: use TEXT around that numeric value with an appropriate format code.
- Apply one consistent style to everything: format the destination cell.
- Style different parts of one result differently: use separate cells, or create static text and format it manually; consider VBA only if the process needs automation.
For example, a mailing label that combines a name, street, and city generally needs readable text and separators, not copied font styles. A dashboard sentence that includes a date or percentage needs TEXT for those values. A heading that must show a red warning word followed by black explanatory text needs a layout or workflow that supports mixed styling; concatenation by itself cannot provide it.
Common problems and how to fix them
A date appears as a number. The formula is joining the date’s numeric value without the date display format. Wrap the date reference in TEXT and specify a date pattern, as in the earlier example.
A currency amount loses its symbol or decimal places. The source cell’s currency display is not necessarily carried into the text. Use TEXT with a currency format code, and check the result for the required number of decimal places and symbol.
There are missing spaces or punctuation. Concatenation inserts only the separators written into the formula. Add a space, comma, line break, or other delimiter explicitly. TEXTJOIN can add a repeated delimiter between cells, but it will not create a custom delimiter after every specific item unless the formula is designed to do so.
Zeros disappear from a code. Check whether Excel stores the code as a number or text. Use TEXT with a zero-padding pattern for numeric values, or preserve the identifier as text at import or entry time.
The result changes when source cells change. That is expected for a formula. If you paste the result as a value to format individual characters, it becomes static. Keep the formula in a separate column or retain a workbook copy if you will need to regenerate it.
The formula displays an error or does not calculate as expected. Confirm that the function name is supported in your Excel version, that text separators are inside straight quotation marks, and that your regional settings accept commas as argument separators. A localized Excel installation may use different function names or list separators. Also check that the destination cell is not formatted as Text, which can cause an entered formula to display as literal text rather than calculate.
Frequently Asked Questions
Does CONCATENATE preserve bold, italic, or font color?
No. It returns combined text and does not carry character-level styling from source cells. You can format the entire result cell, but that affects all of its text.
How do I concatenate a date without getting a number?
Use TEXT around the date reference and provide a date format code, such as TEXT(B2,"mmmm d, yyyy"). Then join that formatted text with the other parts.
Can I bold one word in a CONCAT formula result?
Not through the formula itself. Use separate cells for the differently styled parts, or make a static text value and apply character formatting. A macro can automate some desktop workflows but requires care.
Will CONCATENATE preserve the source cell’s currency format?
No. Use TEXT with a currency format code when you need the amount and symbol to appear a particular way in the joined text. The formula output is text, so formatting the output cell as currency will not selectively format the amount inside the sentence.
Is CONCAT better than CONCATENATE?
CONCAT is the newer function and can join ranges as well as individual values. CONCATENATE is retained for compatibility with older workbooks. Neither preserves rich-text formatting; choose TEXTJOIN when you also want a delimiter and an option to ignore empty cells.
Related
- Change Text to Numbers in Excel: Easy, Reliable Methods
- Center Across Selection in Excel: Add It to Quick Access
- Change Block Capitals to Lowercase in Excel
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Length of Service in Years and Months: FormulasTo calculate completed length of service in years and remaining months, enter the start date in A2 and…
- Excel Formula for Row Number: ROW and ROWS ExplainedTo return the worksheet row number of the cell containing a formula, use =ROW(). To return the row…
- Excel LEN Function: Count Characters in Cells EasilyTo count the characters in a cell, put the text in A2, select another cell, and enter =LEN(A2).…
- COUNTIF Excel Number Range: Count Values by CriteriaTo count numbers in an Excel range that meet a condition, use COUNTIF: for example, with values in…
- Dynamic Drop-Down Lists in Excel Using INDIRECT: How-ToYes. To make a dependent drop-down in Excel, create a named range for each list, then set the…
- Excel AND in MATCH: Find Rows With Multiple CriteriaTo use AND conditions with Excel MATCH, compare each criteria range with its requested value and multiply the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.