Double quotes character string

[Philosophaie]

I want to add a double quote to a string. I know it has a character string name like chr45. It looks like:

a=chr45 & "String1" & chr45

which produces

"String1"

except chr45 is not the correct character string.

 

[cstimart]

I want to add a double quote to a string. I know it has a character string name like chr45. It looks like:

a=chr45 & "String1" & chr45

which produces

"String1"

except chr45 is not the correct character string.

Quick guess: a=chr(34) & "String1" & chr(34)

 

[circledchicken]

Hi,

I think you need CHAR(34) or VBA Chr(34).

One quick way to figure out what code to use is enter =CHAR(ROW()) in A1 and drag down as far as necessary with the rows being the code and the cell showing the associated character.

 

[cstimart]

Hi,

I think you need CHAR(34).

One quick way to figure out what code to use is enter =CHAR(ROW()) in A1 and drag down as far as necessary with the rows being the code and the cell showing the associated character.

If using in an Excel cell, Char(34) is correct....in VBA Chr(34) is correct.

 

[Michael M]

Try, for example

range("A1").Value=Chr(34) & "String" & Chr(34)

 

[Philosophaie]

chr(34) was it thanx.

 

[cstimart]

chr(34) was it thanx.

a = """String1""" would work, too