If the resulting field is more than 32,767 characters it will return an error.Ģnd New Function in Microsoft Excel: TEXTJOIN. In other words, you can join up to 253 items. You can include up to 253 arguments in this formula. This formula replaces the older CONCATENATE formula which still appears in older versions of Excel. To combine text and the value in a cell you could write:. You don’t use quotation marks when referencing cells. Note that the characters you’re including, a comma and space, are enclosed in quotation marks. To combine cells A2 and B2 and place a comma in between them you would write:. If you want to combine cells A2 and B2 you would use the formula:. 
The items you add can be cells, text or a mix and should be separated by commas. To use the CONCAT formula you type =CONCAT and then, in parentheses, add the items you want to join together. The new CONCAT function will also combine (or concatenate) cells.
In a previous post we showed you how to combine cells in Microsoft Excel. New Functions in Recent Microsoft Excel Updates 1st New Function in Microsoft Excel: CONCAT If you’re not on the monthly plan and interested in learning more, check out Microsoft’s Office options here. If you’re on the monthly plan you should already have access to these functions.
0 kommentar(er)
