Concatenate in Excel With Quotes: Formulas and Examples

Formulas & functions · Updated November 22, 2026

To concatenate text in Excel with quotation marks, join the parts with the ampersand operator (&) and use CHAR(34) to add a double quote. For example, if A2 contains Mira, =CHAR(34)&A2&CHAR(34) returns "Mira". You can also put quotes inside a formula’s text by typing each quote twice.

What concatenation means in Excel

Concatenation means joining text or values into one text string. It is useful for building full names, labels, messages, search terms, or lines of text for export. In Microsoft Excel for Microsoft 365 on Windows, the simplest way to join pieces is the ampersand operator. The same formulas work in Excel for Mac and Excel for the web; menu layout and keyboard shortcuts can differ, but the formula syntax is generally the same.

A quotation mark can have two different roles in a formula. Double quotes mark the beginning and end of a text value typed directly into a formula, while quotation marks you want to display are characters in the resulting text. Excel uses doubled quote characters inside a quoted text string to represent one displayed quote. The distinction is important: a formula’s quotes define its text, and its result may contain additional quotes.

For example, with a first name in A2 and a last name in B2, =A2&" "&B2 joins the names with a space. It returns Mira Chen when A2 is Mira and B2 is Chen. To surround the complete result with quotation marks, add the quote characters before and after the joined text.

Put quotation marks around a cell value

The character code for a standard double quotation mark is 34. Excel’s CHAR function returns the character represented by a code, so CHAR(34) produces one double quote. Joining that character on both sides of a cell is an easy-to-read way to wrap its contents.

With the text Mira in A2, enter =CHAR(34)&A2&CHAR(34) in another cell. The result is "Mira", including the visible quotation marks. If A2 instead contains Northwind, the result is "Northwind". The cell contains a text string with quote characters; the quote marks are not merely formatting applied to the cell.

To wrap a combined first and last name, with Mira in A2 and Chen in B2, use =CHAR(34)&A2&" "&B2&CHAR(34). The result is "Mira Chen". This approach is handy when preparing values for a text file, a query, or a message where the quotes need to travel with the text.

You can copy the formula down a column by dragging the fill handle at the lower-right corner of the formula cell. Relative references such as A2 and B2 adjust to A3 and B3 in the next row. If you want to combine cells from the same row, keep the references relative; use dollar signs only when you need a reference to stay fixed while copying.

Type quotes directly inside a formula

When you want a quotation mark as part of a literal text string, type two double quotes for each one you want Excel to display. For example, with no cell references needed, ="She said, ""Go.""" returns She said, "Go.". The doubled quotes inside the formula stand for displayed quote characters, while the outside quotes mark the beginning and end of the text value.

This rule also works when combining fixed text with a cell. With a message in A2, use ="Message: """&A2&""" to place the value between quotation marks after the label. Because long runs of quote characters are difficult to inspect, many people find CHAR(34) clearer when wrapping a cell value. Direct doubled quotes are still useful for short, fixed phrases.

Do not use single quotation marks as a replacement for double quotes around text in an Excel formula. Formula text strings require double quotes. Single quotes have other uses in Excel, such as enclosing worksheet names that contain spaces in a cell reference; they do not create a text string.

Choose between ampersand, CONCAT, and CONCATENATE

For a short formula, the ampersand operator is direct and flexible: place it between each item you want to join. With first name in A2 and last name in B2, =A2&" "&B2 returns Mira Chen. You can mix cells, literal text, and functions in the same expression, which makes it a practical choice for most one-off combinations.

The CONCAT function is another option in current Excel versions. With Mira in A2 and Chen in B2, =CONCAT(A2," ",B2) also returns Mira Chen. It accepts multiple text items and can join a range, but it does not add separators automatically. Put the desired space, comma, or other separator into the formula yourself.

CONCATENATE is the older function name and remains useful when working with older workbooks. With the same values, =CONCATENATE(A2," ",B2) returns Mira Chen. For new formulas, the ampersand operator or CONCAT is usually easier to read. If a workbook must work with an older Excel release, check which functions that release supports before choosing a newer function.

When joining a list of cells with the same separator, TEXTJOIN can be more convenient. With values in A2:A4, use =TEXTJOIN(", ",TRUE,A2:A4) to return the nonblank values separated by comma and space. Its second argument, TRUE, tells Excel to ignore empty cells. TEXTJOIN is available in Excel 2019 and Microsoft 365; it is not necessary for a simple two-cell combination.

Use separators, punctuation, and spacing deliberately

Excel does not insert spaces or punctuation just because two values are joined. Add each separator as a text item in the formula. With A2 containing Mira and B2 containing Chen, =A2&", "&B2 returns Mira, Chen. By contrast, =A2&","&B2 returns Mira,Chen, with no space after the comma.

For a list that should have a comma after every item, joining a range with TEXTJOIN is efficient. If A2:A4 contains red, blue, and green, =TEXTJOIN(", ",TRUE,A2:A4) returns red, blue, green. If a cell is blank, TRUE skips it rather than producing an extra empty position. Set the second argument to FALSE if you need blank cells to count as items in the joined output.

For line breaks inside a result, Windows Excel uses CHAR(10) as a line-feed character. With a label in A2 and a detail in B2, =A2&CHAR(10)&B2 joins them on separate lines. Turn on Home > Wrap Text for the result cell so the line break is visible. On Mac and in the web version, the formula can also contain the line break, though display and row height may need adjustment.

Keep dates, numbers, and codes readable

When a number is joined with text, Excel may convert it to text using a general representation. A date stored as a number can therefore appear as its underlying serial value rather than in the familiar date format. Use the TEXT function when the joined result needs a specific display format.

With A2 containing Mira and B2 containing the date March 5, 2026, use =A2&" - "&TEXT(B2,"mmmm d, yyyy"). The result is Mira – March 5, 2026. The date format inside TEXT controls how the date appears in the combined string; it does not change the stored date in B2.

For a price, with an item name in A2 and the numeric value 1234.5 in B2, use =A2&": $"&TEXT(B2,"#,##0.00"). The result is Mira: $1,234.50. The dollar sign is literal text in the formula, while the format pattern adds a thousands separator and two decimal places. Format codes and separators can display differently under regional settings, so check the output when sharing a workbook across locales.

Codes with leading zeros need special attention. If A2 contains the number 73, joining it directly can produce 73 even if the cell is displayed with a custom format such as 00000. To keep five digits in the combined text, use =TEXT(A2,"00000"), which returns 00073. If the code is an identifier rather than a number for calculation, storing it as text from the start is often safer.

Common problems and how to fix them

  • The formula shows an error. Check that every text string begins and ends with a straight double quote, every function argument is separated correctly, and parentheses are balanced. Excel settings in some regions use semicolons instead of commas between function arguments. If Excel rejects a comma-based formula, check the regional list-separator setting; the examples here use commas.
  • The result has no spaces. Spaces must be included in a text item such as " ". Joining A2 and B2 directly places their contents side by side.
  • The date appears as a number. Wrap the date reference in TEXT and specify the display pattern, as shown above. A cell’s visual number format does not automatically carry over when its value is joined into text.
  • Quotes appear doubled or missing. In a formula’s text literal, doubled quote marks represent one quote in the result. If the formula is becoming hard to count, use CHAR(34) at the point where the visible quote should appear.
  • A blank cell leaves unexpected punctuation. A formula that adds a comma or space unconditionally will still add it when a referenced cell is empty. Use TEXTJOIN with its ignore-empty option for simple lists, or build a conditional formula if punctuation depends on which fields are filled.
  • The formula appears as text instead of calculating. The cell may be formatted as Text, or the formula may have a leading apostrophe. Change the cell format to General, then re-enter the formula. Pressing F2 and then Enter on Windows can re-commit an existing cell; Mac keyboard shortcuts can vary by keyboard and Excel settings.

When concatenated quotes are useful

Adding quotes can prepare a value for a system that expects text enclosed in quotation marks, create a readable label, or show a spoken phrase in a generated sentence. It can also help when assembling delimited text, but a simple concatenation formula is not automatically a complete CSV exporter. CSV has rules for escaping quotation marks and handling separators inside fields, so verify the requirements of the software that will read the result.

For instance, wrapping a product name in quotes is straightforward, but a product name that already contains a quote may require that quote to be escaped or doubled according to the destination format. Excel’s ordinary concatenation only joins characters; it does not know what another application expects. Treat the output as text and test a few representative values before using it for a data import.

Concatenation also produces text, not a new numeric calculation. A result such as "Total: 125" looks informative but is not itself the number 125 for later arithmetic. Keep the original numeric values in their own cells and use a separate display formula when you need a human-readable label. This preserves data that can still be sorted, summed, or analyzed.

Frequently Asked Questions

How do I concatenate text in Excel and put it in quotes?

With the text in A2, use =CHAR(34)&A2&CHAR(34). CHAR(34) supplies one double quote on each side, so a value of Mira returns "Mira".

How do I add double quotes inside an Excel formula?

Double each quote that should appear inside a text literal. For example, ="She said, ""Go.""" displays She said, "Go.". Use CHAR(34) if repeated quote characters make the formula difficult to follow.

Can I use CONCAT to add quotation marks?

Yes. CONCAT joins text items, including the result of CHAR(34). With text in A2, =CONCAT(CHAR(34),A2,CHAR(34)) returns the value surrounded by double quotes. CONCAT does not add quotes automatically.

Why does my concatenated date turn into a number?

Excel stores dates as serial numbers, and concatenation converts the cell value rather than preserving its display format. Use TEXT around the date reference, for example =TEXT(B2,"mmmm d, yyyy"), before joining it with other text.

Does CONCATENATE still work in Excel?

CONCATENATE is retained for compatibility with older workbooks, though CONCAT and the ampersand operator are common choices for newer formulas. For a short formula, ampersands are often the simplest way to see exactly where spaces and quote characters are added.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.