Use formulas to combine spreadsheet data, and use merge cells only for presentation. In both Google Sheets and Microsoft Excel, merging cells can destroy or hide data, while formulas such as TEXTJOIN, CONCAT, and & keep the original values intact. TLDR: If you need to combine names, addresses, product codes, or notes, use TEXTJOIN or […]