Joins three things: the string in cell B2, a space character, and the value in cell C2. Stream population for brook trout species is 32/mile. =CONCAT('Stream population for ', A2,' ', A3, ' is ', A4, '/mile.')Ĭreates a sentence by joining the data in column A with other text.
If you need to, you can adjust the column widths to see all the data.īecause this function allows full column and row references, it returns this result: A’sa1a2a4a5a6a7B’sb1b2b4b5b6b7 For formulas to show results, select them, press F2, and then press Enter. If the resulting string exceeds 32767 characters (cell limit), CONCAT returns the #VALUE! error.Ĭopy the example data in each of the following tables, and paste it in cell A1 of a new Excel worksheet.
Tip: To include delimiters (such as spacing or ampersands ( &)) between the text you want to combine, and to remove empty arguments you don't want to appear in the combined text result, you can use the TEXTJOIN function.
