How to Add Quotes around Numbers or Text in Excel


Have you ever wondered how you can add quotes to the text or words in Excel? Adding quotes is similar to adding symbols as prefix and suffix to the words. It can be done using the "format" function in Excel. In this tutorial, we have provided a detailed step-by-step explanation of how you can add quotes around numbers or text in Excel.

Adding Quotes around Text using "Format Cells" Option

You can use the "Format Cells" option in Excel to add quotes around numbers or text. It is simple process.

Step 1:

Let us suppose we have an Excel sheet with the following data:

To add quotes to the string, select the data, right-click on it, and select the "format cells" option. You will get to see a new pop-up window, as shown in the following screenshot:

Step 2:

Select the option "Custom" in the "Format Cells" window followed by entering "@" in the "Type" field. Click "OK" and observe its effect on the selected data.

This is how you can add quotes to texts using the "Format Cells" option. Note that this method does not apply quotes to numbers. Go through the next section to find out how you can add quotes around numbers.

Adding Quotes around Numbers using Formula

You need to use a Formula to add quotes around numbers in Excel. Let's see how it is done.

Step 1:

Let us consider the same data which we used in the above example. To add quotes to the first cell, select a cell and enter the formula as """"&A1&"""" in the formula box.

Step 2:

To get all the other results, drag down from the corner of the first result till all the results are filled. Our final output will look like the following screenshot:

Conclusion

In this tutorial, we used two different methods to demonstrate how you can add quotes around numbers or text in Excel.

Updated on: 31-Oct-2023

29K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements