| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Write " to a string
Hi
I have to write a single " (quotation mark) to a string but excel takes it as an delimiter. Anyone has a bright idea Thanks in advance Crister |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Write " to a string
MyString ="""
-- Ian -- "thyrmo" wrote in message oups.com... Hi I have to write a single " (quotation mark) to a string but excel takes it as an delimiter. Anyone has a bright idea Thanks in advance Crister |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Write " to a string
I think you mean
MyString = """" Any time you want to embed quote marks in a quoted string they need to be doubled up Debug.Print "This is a ""quoted string""" "Ian" wrote: MyString =""" -- Ian -- "thyrmo" wrote in message oups.com... Hi I have to write a single " (quotation mark) to a string but excel takes it as an delimiter. Anyone has a bright idea Thanks in advance Crister |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Write " to a string
"Charlie" wrote in message
... I think you mean MyString = """" No, thyrmo asked to write a single " into a cell, your solution writes "" instead. -- Ian -- |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Write " to a string
Hi Ian Try running this routine and see what you get. Sub test() a = """" MsgBox a End Sub Dominic -- dominic ----------------------------------------------------------------------- dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893 View this thread: http://www.excelforum.com/showthread.php?threadid=46584 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Write " to a string
Either works to produce just a single "double quote" as the result.
from the immediate window: ? """" " ? """ " -- Regards, Tom Ogilvy "dominicb" wrote in message ... Hi Ian Try running this routine and see what you get. Sub test() a = """" MsgBox a End Sub DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=465843 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Write " to a string
Thanks for the quick reply
and as normal the simplest soultions are the best |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Write " to a string
Good morning Thyrmo The reference number for the " is 34. Therefor the following line would place a single quote in a string contained in the variable a : a=Chr(34) HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=465843 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to write formula for countif (range,"<2" &"3") | Excel Discussion (Misc queries) | |||
| How do I write an excel formula with a text answer ("yes" or "no") | Excel Discussion (Misc queries) | |||
| is it possitle i write"1"and "one" will show in next coloumn. | Excel Discussion (Misc queries) | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
| How can i write a vba code to get string or integer "C15" from $c$15? | Excel Programming | |||
Hybrid Mode
