The formula pattern consists of the following arguments: CONCATENATE text strings and numbers in Google Sheets I believe the Google Sheets CONCATENATE function is the first one to use when it comes to appending several records together. If you still don't get the desired result with these options, there's one more function to try. Not just merge cells in Google Sheets, but also separate them with various characters:.Using an ampersand character (&) in formulas instead of the CONCAT function will provide you with the same result:īut little do you know that this concatenation operator is more flexible. There are lots of different operators for various purposes in formulas. If you try to join multiple cells, you'll either get an error or only the first two values will be joined, like this:ĬONCAT alternative: concatenation operator ampersand (&)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |