Just simply add 2 single quotes, you will get the single quotes enclosed for any string in Excel. Eg: Column A1: '' Column A2: Adam Column A3: '' Column A4: =CONCAT(A1,A2,A3) Result: Column A4: 'Adam'