In Excel, string are marked with the double quote. So, in string concatenation (joining string), you will use the double quote. For example:
However, how would you join two strings which one of the contain the double quote?
The trick would be using three (03) double quotes instead of one:
As you can see, in order to display a quote literally, you will two quotes around it.
So, that’s how you use quotes in string joining in Excel. This works with all versions of Excel.