i need to use commas, semi-colons, and double quotes in a string
users.put(quot;bdubosequot;,quot;1 Barbara Dubose bdubosequot;);
i figured out that i can use quot;quot;quot; and get a double quote but when i try quot;,quot;
for the comma i get an error correction message that offers to correct the
error and drop the , and a different error for quot;;quot; w/o a correction.
thanks
This string concatenates fine on my Excel 97........what version Excel are
you using?
=quot;aquot;amp;quot;,quot;amp;quot;bquot;amp;quot;;quot;amp;quot;cquot;
results to....
a,b;c
give us your actual formula that does not work..........
Vaya con Dios,
Chuck, CABGx3quot;bob alouquot; wrote:
gt; i need to use commas, semi-colons, and double quotes in a string
gt;
gt; users.put(quot;bdubosequot;,quot;1 Barbara Dubose bdubosequot;);
gt;
gt; i figured out that i can use quot;quot;quot; and get a double quote but when i try quot;,quot;
gt; for the comma i get an error correction message that offers to correct the
gt; error and drop the , and a different error for quot;;quot; w/o a correction.
gt;
gt; thanks
=quot;users.put(quot;quot;bdubosequot;quot;,quot;quot;1 Barbara Dubose bdubosequot;quot;);quot;
will output
users.put(quot;bdubosequot;,quot;1 Barbara Dubose bdubosequot;);
if you want quot; to appear in a string you use it twice not three times. The ,
and ; doesn't need anything special.
quot;bob alouquot; wrote:
gt; i need to use commas, semi-colons, and double quotes in a string
gt;
gt; users.put(quot;bdubosequot;,quot;1 Barbara Dubose bdubosequot;);
gt;
gt; i figured out that i can use quot;quot;quot; and get a double quote but when i try quot;,quot;
gt; for the comma i get an error correction message that offers to correct the
gt; error and drop the , and a different error for quot;;quot; w/o a correction.
gt;
gt; thanks
- Oct 22 Sun 2006 20:09
how do i concatenate a string and cell formula and use a comma?
close
全站熱搜
留言列表
發表留言