Yes. In Excel for Microsoft 365 on Windows, enter =""""&A2&"""" in another cell to place straight double quotation marks around the text in A2. For example, if A2 contains apple, the formula returns "apple"; the original cell remains unchanged.
The simplest formula for adding quotes
Excel treats a pair of double quotation marks in a formula as the boundary of a text string. To put an actual quotation mark inside a string, the formula must represent that character by doubling it. That is why the formula above looks as if it contains more quotation marks than the two it produces at each end.
To use it, select an empty cell beside your source text, type the formula, and press Enter. Replace A2 with the address of the cell you want to wrap. The result is text made from an opening quote, the source cell’s value, and a closing quote. It does not change the contents of A2 or add quote characters to the source cell.
A second version uses Excel’s CHAR function. With the source text in A2, enter =CHAR(34)&A2&CHAR(34). Character code 34 represents a straight double quote in Excel. Both formulas produce the same result, so choose the one that is easiest for you to recognize or maintain.
The ampersand joins pieces of text together. In this case, the first piece is a quote, the second is the value from A2, and the third is another quote. You can use the same pattern with a cell in another column or row by changing its reference.
Straight quotes, curly quotes, and apostrophes
The formula using four double quotation marks adds straight quotes: ". These are the plain characters often used in data files, code, and many spreadsheets. Curly opening and closing quotation marks look different: “ and ”. They are sometimes preferred in documents, but software that reads structured data may expect straight quotes.
If you want curly marks, use the source in A2 and enter ="“"&A2&"”". The ordinary straight quotation marks around each formula string tell Excel where that string begins and ends; the curly marks inside the strings are the characters that appear in the result. This formula returns “apple” when A2 contains apple.
A single apostrophe is different from a double quotation mark. Excel also uses a leading apostrophe when you enter a value to make Excel treat it as text; that entry marker normally does not appear as part of the cell’s displayed value. It is not a method for surrounding text with visible quote marks. If the goal is to see a pair of marks in the result, use a formula or enter those characters as part of the cell’s actual content.
Apply the formula to a whole column
For a list, put the formula next to the first item and fill it down. Suppose the values are in A2:A100. With the value to wrap in A2, enter the formula in B2. Then select B2 and use the fill handle, the small square at the lower-right corner of the selection, to copy the formula down alongside the list. Excel adjusts the relative reference as it fills: the next row refers to A3, then A4, and so on.
- Drag the fill handle: Drag the small square down to the last row that has a source value.
- Double-click the fill handle: Excel commonly fills down to match an adjacent continuous column of data. Check the bottom of the results, especially if there are blank rows or gaps.
- Use Fill Down: Select the formula cell and the cells below it, then choose Home > Fill > Down. On Windows, Ctrl+D fills down. In Excel for Mac, Command+D is the corresponding Fill Down shortcut.
These methods copy the formula, not a fixed answer. If A2 changes, the result in B2 updates. If a source range is an Excel table, entering a formula in the result column usually fills the calculated column automatically; verify that the new rows are included if you later extend the data.
Keep number and date displays under control
When Excel joins a cell’s value to text, it may use the value rather than the exact appearance created by the cell’s number format. For instance, a cell displaying 5.00 might contain the number 5. Joining it directly can produce "5", not "5.00". If the number of decimal places matters, use TEXT to specify the desired display.
With the number in A2, enter =CHAR(34)&TEXT(A2,"0.00")&CHAR(34). If A2 contains the numeric value 5, the result is "5.00". The format code 0.00 requests two decimal places; it does not change the value stored in A2.
Dates also have numeric values underneath their display. With a date in A2, enter =CHAR(34)&TEXT(A2,"yyyy-mm-dd")&CHAR(34) to return a quoted date in year-month-day form, such as "2026-11-03" for November 3, 2026. Choose a date pattern that suits the system or person receiving the result. Date conventions vary by region, so a clear year-month-day format can help avoid ambiguity.
Use TEXT only when you need a particular representation. For ordinary names and descriptions, joining the cell directly is simpler. Remember that once a number or date is combined with quote characters, the formula result is text; it is no longer a numeric value suitable for arithmetic or date calculations without conversion.
What changes in the cell, and how to keep the result
A formula produces a separate result; it does not rewrite the source. This is useful when you want to preserve the original list or compare the quoted and unquoted versions. It also means you need to decide what should happen when you share or export the workbook: keep the formulas and their links, or turn the results into fixed text.
To keep fixed quoted text, copy the formula results and paste values into the destination cells. In Excel for Microsoft 365 on Windows, use Home > Paste > Values from the ribbon. The pasted cells contain the text results rather than formulas, so they no longer update when the original cells change. Keep a copy of the original data if you may need to revise the results later.
Do not paste values over the source column if the formula refers to that same column: doing so can replace the data the formula needs. A separate output column is safer. You can also put the fixed results in a new workbook or a different range, depending on how the data will be used.
In Excel for Mac and Excel for the web, the basic formulas work the same way. Ribbon layout and available paste controls can vary slightly by platform or update, but look for the Values option in the Paste controls. The Windows Ctrl+D shortcut is not the Mac shortcut; use Command+D on Mac for Fill Down.
Quotes in a formula are not automatically CSV formatting
A common reason to add quotes is to prepare text for a CSV or another system. Be careful: literal quote characters in a worksheet cell and quotation marks used by a CSV file format are not necessarily the same thing. CSV uses quotes to delimit fields when needed, for example when a field contains a comma, a line break, or a quotation mark. An export program may add and escape those formatting marks as it writes the file.
If you add visible quote characters with a formula and then save as CSV, the export may also apply its own quoting rules. The resulting file can therefore contain extra-looking quote marks, or internal quotes may need escaping. Do not assume that adding quote characters in cells is required just because a recipient asks for a CSV. Confirm the required layout with the application or person that will import the file, and inspect a copy of the exported file before using it for a large transfer.
For example, a value containing a comma may need to be enclosed in quotes in a CSV field so the comma is not mistaken for a field separator. That does not mean the quote characters have to be part of the worksheet value first. Conversely, if the receiving system explicitly requires quote marks as part of each text value, a formula can create those characters, but check how the system handles them on import.
Common problems and practical alternatives
- The formula displays an error or unexpected marks: Check that every opening formula string has a matching closing quotation mark, and that the cell reference exists. The formula with four quote marks on each side is easy to mistype; the CHAR(34) version can be easier to inspect.
- The quote marks do not appear in the source cell: That is expected. The formula returns its result in another cell. To make the characters part of a fixed value, copy the results and paste values, or edit the original cells directly if preserving the original text is not important.
- A number loses trailing zeros: Joining the value directly does not necessarily preserve its displayed number format. Use TEXT with an explicit format such as
0.00when two decimal places are required. - The result has quotes but will not calculate as a number: The formula creates text by design. Keep a separate numeric source column for calculations, and use the quoted output only for display or transfer.
- You only want quotes to appear on screen: A formula is usually clearer for text because it creates an explicit text result. A custom number format is mainly for changing how eligible values display; it does not add quote characters to the underlying value. Do not rely on visual formatting when another program must receive actual quote characters.
For a small number of cells, you can type the quote characters directly into each value, but that is slower and easier to do inconsistently across a large list. A fillable formula is generally the practical choice when the output should update with its source. For a one-time fixed list, formulas followed by Paste Values provide a straightforward middle ground.
Frequently Asked Questions
Can Excel add quotes around text without changing the original cell?
Yes. Put the formula in a different cell. It creates a quoted text result while leaving the source cell unchanged.
What formula puts double quotes around a cell?
If the text is in A2, use =""""&A2&"""". The CHAR alternative is =CHAR(34)&A2&CHAR(34).
How do I add quotes around every item in a list?
Enter the formula beside the first item, then fill it down using the fill handle or Home > Fill > Down. Relative references adjust for each row.
Can I add curly quotation marks instead?
Yes. With text in A2, use ="“"&A2&"”". The output has a curly opening mark and a curly closing mark rather than straight quotes.
Why did my quoted number lose its decimal places?
Excel may use the underlying numeric value when it joins text, rather than the cell’s displayed format. Wrap the number with TEXT and specify the required format, such as 0.00.
Do I need to add quotes in Excel before saving a CSV?
Not always. CSV export can add quotation marks to fields when the format requires them. Add literal marks in the worksheet only when the receiving system specifically requires them as part of each value.
Related
- Dynamic Calendar Excel Template: Build One That Updates
- Dynamic Checklist in Excel: Build One That Updates
- Excel Dependent Dropdowns: How to Create Linked Lists
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel What-If Analysis: Tools and ExamplesExcel What-If Analysis lets you change assumptions in a worksheet and see how those changes affect a result.…
- How to Call a Function in Snowflake (Step-by-Step)Calling a function in Snowflake means executing a built-in or user-defined function (UDF) to return a value, transform…
- Weighted Average in Excel: Formula and ExampleIn Excel, calculate a weighted average by multiplying each value by its weight, adding those products, and dividing…
- How to Use VLOOKUP Between Two Worksheets in ExcelTo use VLOOKUP between two sheets in Excel, enter a formula on the sheet where you want the…
- Excel INDIRECT Function: Reference Another SheetYes. In Excel, INDIRECT can turn a text string containing a worksheet reference into a usable reference. For…
- Concat Excel Cell Range: Join Cells With Simple FormulasWith the values to join in A2:A5, enter =CONCAT(A2:A5) to combine the range into one text string; for…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.