The string 'Hello ' has an extra space added. For example: =CONCATENATE('Hello ', 'World!'). For example: =CONCATENATE('Hello', ' ', 'World!').Īdd a space after the Text argument. There are two ways to do this:Īdd double quotation marks with a space between them ' '. Add extra spaces as part of the CONCATENATE formula. Without designated spaces between separate text entries, the text entries will run together. Numbers don't need to have quotation marks. For example: Excel will display =CONCATENATE('Hello ''World') as Hello'World with an extra quote mark because a comma between the text arguments was omitted. Use commas to separate adjoining text items. Joins the same items as the previous example, but by using the ampersand ( &) calculation operator instead of the CONCATENATE function. Joins three things: the string in cell B3, a string consisting of a space with ampersand and another space, and the value in cell C3. Joins three things: the string in cell C2, a string with a comma and a space character, and the value in cell B2. Joins three things: the string in cell B2, a space character, and the value in cell C2. The result is Stream population for brook trout species is 32/mile. To use these examples in Excel, copy the data in the table below, and paste it in cell A1 of a new worksheet.Ĭreates a sentence by joining the data in column A with other text. You can have up to 255 items, up to a total of 8,192 characters. The item can be a text value, number, or cell reference.Īdditional text items to join. =CONCATENATE('Stream population for ', A2, ' ', A3, ' is ', A4, '/mile.') This is because CONCATENATE may not be available in future versions of Excel. Although the CONCATENATE function is still available for backward compatibility, you should consider using CONCAT from now on. Important: In Excel 2016, Excel Mobile, and Excel for the web, this function has been replaced with the CONCAT function.

Join together definition