Joining cells into one can be done in a couple of ways in Excel. The CONCAT function in Excel joins things together. CONCAT is short for concatenate. There is actually a concatenate function as well, and this does exactly the same thing, but it is an older function, and if you have a newish version of Excel (and anyone you are sharing your spreadsheet with also has a newish version) you are probably better off using CONCAT. (It is in the 2016 version onwards.)
For example, we have used CONCAT to combine the first name with the last name. We have also specified to include a space between the names.
=CONCAT(text1, [text2],…) is the general layout for the function. You can include almost as many texts to combine as you want, but the result can’t be bigger than 32,767 characters long!
If you do have a few cells to join and you always want to have the same thing between each of the texts you specify then TEXTJOIN might be a better option.
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
Delimiter is what you want to use to separate each of the texts.
ignore_empty allows you to specify what you want to happen if one of the text you include is empty. Should it be ignored, or included as a space? Putting TRUE will ignore the empty texts.
You can include up to 256 Texts to then join.
Notice I have specified the delimiter to be colon space and this is what has been put between each of the words. You do have to put the delimiter in quote marks.
So next time you need to do some joining consider whether CONCAT or TEXTJOIN suits your needs best.