The syntax of the CHAR function is as below:=CHAR(number)…. The Excel CHAR function returns the character specified by a number (ASCII Value).The CHAR function is a build-in function in Microsoft Excel and it is categorized as a Text Function. The excel CONCAT function combines 2 or more strings or ranges together.This is a new function in Excel 2016 and it replaces the CONCATENATE function.The syntax of the CONCAT function is as below:=CONCAT (text1,…)… A new column with the merged text will be added to the preview. You can also name the column from this window. In our case, we want a space between the names. Select your choice for how you want the text from each column to be separated. That will bring up the Merge Columns Window. If you want to remove non numeric characters from a text cell in excel, you can use the array formula:… Related Functions Then select Merge Columns on the Add Column tab. remove non numeric characters from a cell.For instance, if we have data in cell A2 and want to use that in cell A1, use A2 in cell A1, and this will copy the A2 value in A1. If you want to remove numeric characters from alphanumeric string, you can use the following complex array formula using a combination of the TEXTJOIN function, the MID function, the Row function, and the INDIRECT function.… Not only cell reference, but we can also include our own values with cell references Cell References Cell reference in excel is referring the other cells to a cell to use its values or properties. It can join the text from two or more text strings or multiple ranges into one string and also can specify a delimiter between the combined text strings. If you are using the excel 2016, then you can use a new function TEXTJOIN function to combine text from multiple cells, it is only available in EXCEL 2016. If you want to add line break into the combined text string, you can use the CHAR function within the CONCATENATE function, just use the below formula: = CONCATENATE(B1, CHAR(10),B2, CHAR(10),B3) Just like the below formula: = CONCATENATE(B1," ",B2," ",B3) Note: If you want to add a space between the combined text strings, you can add a space character (“ “) enclosed in quotation marks. (Select Cell C1)Ģ# type the following formula in Cell C1. Just following the below steps to join combine the text from B1:B3 into one Cell C1.ġ# Select the cell in which you want to put the combined text. If you want to join the text from multiple cells into one cell, you also can use the CONCATENATE function instead of Ampersand operator.