Using " " within ""

[GeneralShamu]

I am trying to write something like this in a cell:

="Tom said "Hello" when Sally came by."

i.e. to use " " in a String
When I try to use it I get an error, does anyone know the trick to using these in formulas? I know JAVA tends to use \...

 

[IvenBach]

"Tom said ''Hello'' when Sally came by."
The ' in Hello is a single apostrophe not a natural double. That should work

*Edit: I don't know if you can use the " like you want to as a formula

 

[jeffreybrown]

If you want the quotes around Hello then...

="Tom said ""Hello"" when Sally came by."

If you don't want those quotes then...

="Tom said Hello when Sally came by."

 

[IvenBach]

I stand corrected. jrb do you know why when you put "" in the quote still appeared around Hello in the cell? I thought it would take them out same as if you put in an &. Could you explain this for me?

 

[jeffreybrown]

Hi IvenBach,

Well I don't have a reference for why this is needed, but besides seeing others on this forum use it that way I can simply say it's used because you are forcing Excel to see Hello as text. Maybe somebody can point us in the right direction as to a better explanation.