how do i concatenate a string and cell formula and use a comma?
 

i need to use commas, semi-colons, and double quotes in a string

users.put("bdubose","1 Barbara Dubose bdubose");

i figured out that i can use """ and get a double quote but when i try ","
for the comma i get an error correction message that offers to correct the
error and drop the , and a different error for ";" w/o a correction.

thanks

how do i concatenate a string and cell formula and use a comma?
 

This string concatenates fine on my Excel 97........what version Excel are
you using?

="a"&","&"b"&";"&"c"
results to....
a,b;c

give us your actual formula that does not work..........

Vaya con Dios,
Chuck, CABGx3


"bob alou" wrote:

i need to use commas, semi-colons, and double quotes in a string

users.put("bdubose","1 Barbara Dubose bdubose");

i figured out that i can use """ and get a double quote but when i try ","
for the comma i get an error correction message that offers to correct the
error and drop the , and a different error for ";" w/o a correction.

thanks

how do i concatenate a string and cell formula and use a comma?
 

="users.put(""bdubose"",""1 Barbara Dubose bdubose"");"

will output

users.put("bdubose","1 Barbara Dubose bdubose");

if you want " to appear in a string you use it twice not three times. The ,
and ; doesn't need anything special.

"bob alou" wrote:

i need to use commas, semi-colons, and double quotes in a string

users.put("bdubose","1 Barbara Dubose bdubose");

i figured out that i can use """ and get a double quote but when i try ","
for the comma i get an error correction message that offers to correct the
error and drop the , and a different error for ";" w/o a correction.

thanks