To add single quotes at the beginning and end of strings in Excel, use the CONCATENATE function. The syntax is =CONCATENATE("'", A1:CI1, "''"), where A1:CI1 is the cell range. This formula adds a single quote before and after the text in the specified range.