How to Add Quotes around Cell Values in Excel

This post will guide you how to add double quotes around cell values with a formula in your worksheet in Excel. How do I add quotes around each value of cells in Excel 2013/2016. How to add double quotes inside a formula in Excel.

Assuming that you have a long list of names that need to have quotes( it can be double or single quotes) around each name values. If there is a useful formula to add quotes to the name in each row or column.

Adding Quotes around Cell Values


If you want to add quotes around text values for the specified cells or enclose all specified cell values with double quotes in range A1:A5, just do the following steps:

Step 1: you can type the following formula based on the CHAR function in Cell B1.

=CHAR(34) & A1 & CHAR(34)

or

= " ' " & A1 & " ' "

Add Quotes around Cell Values1
Step 2: you need to drag the AutoFill handle in Cell B1 down to other cells to apply this formula. Then you would see that all the cell values have been enclosed with double quotes or single quotes.

Add Quotes around Cell Values2

Adding Quotes inside a Fromula


If you want to include double qutotes inside a formula in Excel, and you can use additional double qutoes as escape characters. For example, you wish to add double qutoes around a text, and you can also use the below formula:

= " "" " & A1 & " "" "

Add Quotes around Cell Values3

Related Functions


  • Excel CHAR function
    The Excel CHAR function returns the character specified by a number (ASCII Value). The syntax of the CHAR function is as below: =CHAR(number)….
Related Posts

How to Average Only Positive or Negative Numbers of a Range

Suppose both positive numbers and negative numbers exist in a table. If we want to know the average of only positive numbers in this table, we can create a formula to get average of all positive numbers with all negative ...

How to Sort Data but Keep Blank Cells in Excel

In daily work, if we sort data with blank cells included in the same column, these blank cells are listed at the bottom automatically after sorting. If we want to keep the positions of these blank cells unchanged and only ...

How to Copy and Paste Only Values and Ignore Formula

When we copy a cell applied with a formula, we copy the formula of the cell rather than copy the value showing in the cell. In this article we will introduce you the way to copy only value ignoring applied ...

How to Sort Date by Day of Week in Excel

Except sort data by “A to Z” (alphabetical order, for numbers from small to large), we can also sort data by date, month or year if these conditions are given. In this article, we will show you the way to ...

How to Select All Non-Blank Cells of a Range

In daily work, we may meet the cases that select all blank cells or non-blank cells of a range. You may know the way to select all blank cells as they are “blanks”. But for non-blank cells, they may contain ...

How to Warp X-Axis labels in Excel
warp x axis label2

This post will guide you how to wrap the text of x-Axis labels on Excel Charts. How do I wrap x axis labels in a chart in Excel 2013/2016. Warp X Axis Labels Assuming that you have created a column ...

How to Remove Specific Character from Text Cell in Excel
remove specific character from text string6

This post will guide you how to remove a specific character from text cell in Excel. How do I remove certain character from a cell with a formula in Excel 2013/2016. Remove Specific Character Using Find and Replace function Remove ...

How to Concatenate Data with a Line Break in Excel
concatenate cells with line break3

This post will guide you how to combine multiple cells with line break in Excel. How do I concatenate cells with a line break character into one cell with formula in Excel. Concatenate Data with Line Break Character You can ...

How to Remove Line Breaks (Carriage Returns) in Excel
remove line breaks9

This post will explain that how to remove line breaks in your data set in Excel. How do I remove carriage returns or line breaks with a formula in Excel. How to remove line breaks with VBA Macro in Excel. ...

Generate Random Character Strings
generate random strings9

This post will guide you how to generate a random character string in excel. How do I create a random passwords, text strings with a formula in excel. How do I generate random strings of characters with VBA code in excel. ...

Sidebar