For example, you can substitute =CONCATENATE(A1, A2) by =A1&A2. You can use it by adding the & symbol between the two values that you want to combine. There is an alternative to the concatenate function that is very convenient because of its shorter notation. Concatenate alternative: the Ampersand & operator If they wouldn’t have, the result would for example be Hi there,Mr.Charly (Note the lack of spaces).Īnother way to add spaces in between words is by adding the space in the concatenate function itself, like so: =CONCATENATE(C2, " ", B2, " ", A2). We do need to mention that the Title and Greeting column have an extra space after the values. ) and A2 ( Charly) we end up with the text Hi there, Mr. So by combining C2 ( Hi there, ), B2 ( Mr. The Concatenate function in the Complete message column combines the values in the columns to its left.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |