Select the cell where you need the result.Here are the steps to concatenate an Excel range without any separator (as shown in the pic): CONCATENATE Excel Range (Without any Separator) Note: If you’re using Excel 2016, you can use the TEXTJOIN function that is built to combine multiple cells using a delimiter. In this tutorial, I will show you how to combine multiple cells by using the CONCATENATE function. While you can enter the reference one by one within the CONCATENATE function, it would not work if you enter the reference of multiple cells at once (as shown below):įor example, in the example above, while the formula used is =CONCATENATE(A1:A5), the result only shows ‘Today’ and doesn’t combine all the cells. =CONCATENATE(A1&A2) will give you the result as GoodMorning (where A1 has the text ‘Good’ in it and A2 has the text ‘Morning’.=CONCATENATE(“Good”,” “, “Morning”) will give you the result as Good Morning.=CONCATENATE(“Good”,”Morning”) will give you the result as GoodMorning.In its basic form, CONCATENATE function can join 2 or more characters of strings.

If you’re not using Office 365, keep reading. If you’re using Excel with Office 365 subscription, I suggest you click here to skip to the part where the TEXTJOIN function is covered.