Forum Discussion
Solved
Trying to add double quotes to the Concat formula
How is it possible to add a double quote to a string being built with a Concat formula
Or, staying with CONCAT:
=CONCAT("""", A1, B1, C1, """")
or, using CHAR(34):
=CONCAT(CHAR(34), A1, B1, C1, CHAR(34))
2 Replies
Or, staying with CONCAT:
=CONCAT("""", A1, B1, C1, """")
or, using CHAR(34):
=CONCAT(CHAR(34), A1, B1, C1, CHAR(34))
HansVogelaar thanks. That did the trick
