Sometimes we use double quotes to demonstrate something important or to highlight some phrase or topic. But inserting a double quote in an Excel cell is quite tricky. And to join texts that contain double quotes needs some technique. That’s when the CHAR function, including the number 34, is needed in Excel. In this article, I will show you how to use the CHAR(34) function in Excel.
Download Practice Workbook
You can download the free Excel workbook here and practice on your own.
Introduction to The CHAR Function
The CHAR function will return a character specified by one single code number assigned from the character set for your computer.
The syntax or formula for the CHAR function in Excel is,
|number||Required||Here, a number between 1 to 255 is given as an input to assign the specific character for that number.|
The CHAR function will return a character specifically for the number given as an argument.
CHAR(34) Function in Excel
As mentioned earlier this function takes numbers between 1-255 as input. After taking input, it returns a symbol or character as the output for that ASCII number. These ASCII numbers include English letters, numbers or symbols, etc. The CHAR(34) function in Excel will return a double quote (“) as the output after inserting it in any phrases or Excel formulas.
2 Handy Examples of Using CHAR(34) Function in Excel
In this article, you will see two easy examples to use the CHAR(34) function (double quotes) in Excel. First of all, I will directly insert double quotes between phrases in an Excel cell by using the CHAR(34) function. Secondly, I will apply the CHAR(34) function with multiple formulas for the same purpose.
Here, I will use the following data set to complete my procedures. I will join the phrases from the following image and turn them into a complete sentence, while Phrase 2 will have double quotes.
Example 1: Inserting Double Quotes by Using CHAR(34) Function
In the first example, I will simply insert double quotes between two phrases using the CHAR(34) function. Also, I will demonstrate the difference between inserting double quotes in a phrase manually and using this function. For a better understanding, go through the following steps.
- First of all, to make a complete sentence and add double quotes, see the following sequence in cell D5.
="My favorite "&B5&" is "&""""&C5&""""&"."
- Here, to add the double quotes inside the phrase of cell C5, I have written two extra double quotes(“”) before and after C5 in the above sequence.
- Secondly, press Enter to see the result, and you will find the double quotes before and after the book name in C5.
- Here, applying too many double quotes will confuse the users.
- Hence, in the following steps, I will show the use of the CHAR(34) function to do the same.
- Thirdly, again in cell D5, use the following formula, that now contains the CHAR(34) function instead of the double quotes.
="My favorite "&B8&" is "&CHAR(34)&C8&CHAR(34)&"."
- Fourthly, press Enter to see the complete sentence in cell D5.
- Then, to get all the completed sentences through this formula in the lower cells, use AutoFill.
- Moreover, you may have to rewrite the phrases or modify the sequence of the above formula for your own use.
Example 2: Applying CHAR(34) Function with Multiple Functions in Excel Formula
In this second example, I will apply the CHAR(34) function inside multiple functions. For example, I will take the IF function of Excel to demonstrate this procedure. Generally, users get the return from the IF function in a text format without any symbol or quote in it. So, I will use the CHAR(34) function to show the output from the IF function along with double quotes.
- Firstly, in cell D5, use the following formula containing both IF and CHAR(34)
- Here, by looking at the above formula, you can notice that I added the CHAR(34) function before and after the outputs.
- So, the IF function will return the specific output with double quotes.
- Secondly, press Enter to see the output with double quotes around it.
- Then, use Fill Handle to get the desired output for the lower cells as well.
That’s the end of this article. I hope you find this article helpful. After reading the above description, you will be able to learn how to use CHAR(34) in Excel. Please share any further queries or recommendations with us in the comments section below.
The ExcelDemy team is always concerned about your preferences. Therefore, after commenting, please give us some moments to solve your issues, and we will reply to your queries with the best possible solutions.