Using " " within ""

GeneralShamu

Board Regular
Joined
Jul 6, 2007
Messages
127
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 \...
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
"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
 
Last edited:
Upvote 0
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."
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,556
Messages
6,114,284
Members
448,562
Latest member
Flashbond

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top