Combine Cells in Google Sheets - Using Ampersand (&) Operator
Mon Aug 12 2024 16:04:15 GMT+0000 (Coordinated Universal Time)
Saved by @baamn
One of the simplest ways to combine text in Google Sheets is to use the ampersand (&) operator. This operator allows you to join two or more strings of text together. To use the ampersand operator, simply type an ampersand between the two cells that you want to combine. For example, if you have the first name in cell A1 and the last name in cell B1, you can combine them using the following formula:
https://coefficient.io/google-sheets-tutorials/how-to-combine-text-from-two-cells-in-google-sheets
Comments