How to Put Quotation Marks Around Text in Excel

Adding quotation marks around text can be useful for a variety of reasons, such as when you want to highlight a specific quote or when you want to protect certain data from being edited.

Using the TEXTJOIN Function

Select the range of cells that contains the text you want to add quotation marks to.
In the formula bar, enter the following formula: =TEXTJOIN(""",",TRUE,A1:A10)
Press Enter.

The TEXTJOIN function will concatenate the values in the specified range of cells, inserting a double quotation mark between each value. For example, if the range A1:A10 contains the values “Hello”, “World”, and “!”, the formula would produce the result: "Hello""World""!"

Using the SUBSTITUTE Function

Select the range of cells that contains the text you want to add quotation marks to.
In the formula bar, enter the following formula: =SUBSTITUTE(A1:A10,"","")
Press Enter.

The SUBSTITUTE function will replace all occurrences of a specified substring with another substring. In this case, we are replacing all occurrences of an empty string (i.e., nothing) with a double quotation mark.

Using the Format Painter

Select a cell that contains the text that you want to add quotation marks to.
Right-click on the cell and select “Copy”.
Select the range of cells that you want to add quotation marks to.
Click on the “Format Painter” button in the Clipboard group on the Home tab.
Click on a cell in the range that you want to add quotation marks to.

The Format Painter will apply the formatting from the copied cell to the selected range of cells, including the quotation marks.

Conclusion

There are a few different ways to add quotation marks around text in Excel. The method that you choose will depend on your specific needs. If you need to add quotation marks to a large number of cells, using the TEXTJOIN or SUBSTITUTE function is likely to be the most efficient method. If you only need to add quotation marks to a few cells, using the Format Painter may be the simplest method.

Also Read: How Do You Get The Mystery Box In Call Of Duty Black Ops

Recommend: Why Is Tyrann Mathieu Called The Honey Badger

Related Posts: What Is The Definition Of Assumption

Also Read: How Many People In Europe

Recommend: What Is A Good Dating Headline