How can I include quotations in a CONCATENATE operation?

Option 1: You can use CHAR(34) to represent quotes. For your example:

=CONCATENATE("COPY ", CHAR(34), A2,"*.*",CHAR(34)," ",CHAR(34), B2,"*.*",CHAR(34), "/Y")

Option 2: You can also create a Name for Char(34) and use it instead of typing the formula each time you need quotes.

enter image description here

Example:

=CONCATENATE("COPY ", quot, A2, "*.*", quot, " ", quot, B2, "*.*", quot, "/Y")

Option 3: You can also enter a single quotation mark into a blank cell and just point to it in your formula.

Example:

=CONCATENATE("COPY ", F1, A2, "*.*", F1, " ", F1, B2, "*.*", F1, "/Y")

where F1 contains "

= "Copy """ & A1 & "*.*"" """ & B1 & "*.*"" /Y"

Related