Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
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 Enclose All Cells in Quotes or Insert Quotes around Text in Excel?
When you need to export data to a format that demands quoted text, for example, or when you wish to concatenate text with other values, adding quotation marks around text in Excel can be helpful in a variety of situations. You may simply prepare and alter your data using this straightforward method without using laborious manual editing or complicated formulae. In this article, we'll look at a variety of ways, from simple ones to more intricate ones, for enclosing cells in quotations. So, let's get started and discover how quick and simple it is to create quotations around text in Excel!
Enclose All Cells in Quotes or Insert Quotes around Text
Here we will first get any one of the values using the formula, then use the autofill handle to complete the task. So let us see a simple process to know how you can enclose all cells in quotes or insert quotes around text in Excel.
Step 1
Consider an Excel sheet where you have a list of strigs.
First, click on an empty cell, in this case cell B2, and enter the formula as =CHAR(34) & A2 & CHAR(34) and click enter to get the first value. In the formula, A2 is the address of the cell.
Empty Cell > Formula > Enter.
Step 2
Then drag down using the autofill handle to complete the task.
This is how you can enclose all cells in quotes or insert quotes around text in Excel.
Note
Some of the other formulas to perform the same task are
For single quotes, use ="'" & A1 & "'"
For two quotes, use =""""&A1&""""
Conclusion
In this tutorial, we have used a simple example to demonstrate how you can enclose all cells in quotes or insert quotes around text in Excel to highlight a particular set of data.
293 Views
