Excel Formulas to Insert Double Quotes Inside the Output Cell!!
Tags: excelformula, excelformulas
Published: 2021-06-18 09:47:59

---
title: Excel Formulas to Insert Double Quotes Inside the Output Cell!!
published: true
date: 2021-06-07 11:47:28 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-insert-double-quotes-inside-the-cell/
---

If you need to **insert single or double quotes around the cell** to enclose the text value, do you have any quick methods to solve it? This article will introduce some good ways to deal with this job in Excel. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Insert double quotes inside the cell](https://geekexcel.com/wp-content/uploads/2021/06/Insert-double-quotes-insise-the-cell.png)](https://geekexcel.com/excel-formulas-to-insert-double-quotes-inside-the-cell/insert-double-quotes-insise-the-cell/#main)<figcaption id="caption-attachment-46187">Insert double quotes inside the cell</figcaption>

## Generic Formula:

- If you want to include the single or double quotes around the cell in Excel, you can use the below formula.

**=”Text”””&A1&”””Text”**

## Syntax Explanations:

- **A1** – It represents the input cell.
- **Text** – It is the text that you want to display the cell.

## Practical Example:

Let’s consider the below example image.

- First, we will enter the input movie names in **Column B**.
- Now we need to include double quotes inside a cell.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/06/Input-Range-7.png)<figcaption id="caption-attachment-46186">Input Range</figcaption>

- Select any cell and type the above-given formula.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/06/Enter-the-formula-23.png)<figcaption id="caption-attachment-46185">Enter the formula</figcaption>

- Finally, press the ** ENTER** key, you can get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/06/Result-20.png)<figcaption id="caption-attachment-46188">Result</figcaption>

## Conclusion:

From this chapter, you can get some clarification on how to **insert single or double quotes around the cell**  **to enclose the text value in Excel**. Hope you like it. We welcome your **comments** and **questions** about this lesson.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Also:

- **[Formulas for Counting Unique Values in a Range with COUNTIF in Excel!!](https://geekexcel.com/formulas-for-counting-unique-values-in-a-range-with-countif-in-excel/)**
- **[Excel Formulas to Count Line Breaks in A Cell ~ A Complete Guide!!](https://geekexcel.com/excel-formulas-to-count-line-breaks-in-a-cell/)**
- **[Formulas for Counting Non-Contiguous Range in Excel Using COUNTIF!!](https://geekexcel.com/formulas-for-counting-non-contiguous-range-in-excel-using-countif/)**
- **[Excel Formulas to Clean  Reformat Telephone Numbers ~ Simple Tips!!](https://geekexcel.com/excel-formulas-to-clean-and-reformat-telephone-numbers/)**