This will result in "Leonardo da Vinci" in cell D1. In this case you would write =CONCAT( in cell D1, then click on cell A1, type a semicolon, then type the space surrounded by strings, " ", followed by another semicolon, and finally click on cell B1. If you want to add text in between the different cells' content, for example a space, you can click on a cell, then type a semicolon and the text you want to add in between quotes, then another semicolon, and finally click on the next cell: After that, pressing Enter will give the result in the cell D1. Like you can see in these screenshots, we are writing =CONCAT( in the cell D1 and then clicking on the cells A1 and B1 while keeping Ctrl pressed. To use the CONCAT function, you will need to click on the cell in which you want the result to appear, and type =CONCAT( there.Īfter that you can click on the cells, or range of cells, you want to concatenate (or join) together – you will need to keep the Ctrl button pressed to add multiple arguments. There can be up to 253 text arguments, and each one can also be a string or an array of strings (such as a range of cells). identifies the optional arguments that follow. text1 is a required argument that can be a string or an array of strings (like a range of cells).The general syntax of the CONCAT function is: =CONCAT(text1 ) And in Excel, you can use the CONCAT function to join data from multiple cells into one cell. In this guide you will learn about the CONCAT function and how to use it.Ĭoncatenation just means to join two things together. Excel has many useful functions that you can use to work with your data.
0 Comments
Leave a Reply. |