- Trending Categories
- Data Structure
- Operating System
- MS Excel
- C Programming
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
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.
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:
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.
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.
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:
In this tutorial, we used two different methods to demonstrate how you can add quotes around numbers or text in Excel.
Kickstart Your Career
Get certified by completing the courseGet Started