View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default 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