How do you write " as part of a text string?

[PATSYS]

For example part of the text string should appear as

"Sheet1"

I wrote it in the formula as:

="""&"Sheet1"&"""

But excel returned error.

How should it be done?

Thanks

 

[Richard Schollar]

Hi Patsys

I usually use:

=CHAR(34) & "Sheet1" & Char(34)

Best regards

Richard

 

[fairwinds]

Hi,

Try:

=""""&"Sheet1"&""""

 

[tusharm]

To put a single quote inside a string literal, use two quotes. So, in your case use """Sheet1"""

For example part of the text string should appear as

"Sheet1"

I wrote it in the formula as:

="""&"Sheet1"&"""

But excel returned error.

How should it be done?

Thanks

 

[PATSYS]

Thanks guys, I didn't know that rule.