How can I construct the following string in an Excel formula:
Maurice "The Rocket" Richard
If I'm using single quotes, it's trivial = "Maurice 'The Rocket' Richard" but what about double quotes?
Thanks
+13
A:
Have you tried escaping with a double-quote?
= "Maurice ""The Rocket"" Richard"
YonahW
2008-10-19 16:33:40
Works like a charm.
Allain Lalonde
2008-10-19 16:52:05
Would that be a 'double double-quote'? :)
Jonathan Leffler
2008-10-19 17:54:09
If you want a string that just consists of a double quote, you need """" which I make a double double double-quote.
Mike Woodhouse
2008-10-19 19:46:04
+3
A:
Alternatively, you can use the CHAR function:
= "Maurice " & CHAR(34) & "Rocket" & CHAR(34) & " Richard"
Dave DuPlantis
2008-10-20 13:41:42
A:
will this work for macros using .Formula = "=THEFORMULAFUNCTION("STUFF")" so it would be like: will this work for macros using .Formula = "=THEFORMULAFUNCTION(CHAR(34) & STUFF & CHAR(34))"
eric
2010-08-17 14:22:16
Don't know if this particular syntax is available in VBA. Give it a try.
Allain Lalonde
2010-08-17 16:15:48
Looks like a yes: http://bytes.com/topic/access/insights/575414-quotes-double-quotes-where-when-use-them
Allain Lalonde
2010-08-17 16:16:47