Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

#### Post your problem and you’ll get Expert help in seconds.

Your message must be at least 40 characters
Our professional Expert are available now. Your privacy is guaranteed.

# Double quotes inside a formula – PENDING

## Formula

`=""""&A1&""""`

## Explanation

While using Excel, if you need to add double quotes in any formula that you want to use, you are required to use another double quote which can be called escape characters. What does escape character mean? Actually, it tells the Excel to consider characters as a part of the actual text. Apart from this, the rule of applying quotes in any formula you normally use remains the same.

## Example

If you want to apply double quote on a word “Hello” in cell B2 so you can use this formula like this:

`=""""&B2&""""`

If you want to put double quotes around the movie name, you can simply apply this formula to the movie name, assuming the above example ‘Hello’ is a movie name and then

## Formula

`="The famous movie """ &B2&""" was released in 2000"`

The result of this command would be: The famous movie “Hello” was released in 2000.

Another way of doing it to use CHAR function with number 34. So, the command becomes

`="The famous movie "&CHAR(34)&A1&CHAR(34)&" was released in 2000"`

CHAR(34) helps to bring double quote character in the output as a part of the actual text.

Solution examples
I have 4 column. when i fill the first 3 column. in 4th column i need a unique id number and i generate unique id number using RANDBETWEEN formula [ =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1000,9900) ] but i want ..... when i'm filling the 3 column after that 4th column run this formula and generate unique id automatically
Solved by X. Q. in 20 mins
when i fill column A and B then C column generate Unique ID using RandBetween Formula {=CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(65,90))&RANDBETWEEN(1000,9900)} ...
Solved by S. Q. in 20 mins