![]() ![]() Now you have several rows of data merged into one row. In practice, you may often need to concatenate more cells, so your real-life formula is likely to be a bit longer: Merge rows and separate the values with comma and space:Ĭombine rows and separate the values with commas without spaces: Either way, you supply cells as references and type the desired delimiters in-between. To joint the values from several cells into one, you can use either the CONCATENATE function or concatenation operator (&).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |