Select Combine rows option in the To combine selected cells according to following option section: See screenshot:Īnd then you will see selected columns are merged into one column, and cells in each row are concatenated into the first cell of this row. (4) In the Options section please check the Delete contents of combined cells option.
(3) Specify an option from the Place the results to drop down list. In our case, we check the New line option (2) In the Specify a separator section, check a separator as you need. In our case, we check the Combine Columns option (1) In the To combine selected cells according to following options section, specify a combination option based on your need.
In the opening dialog box, please do as follows: Select the range you will concatenate, and click Kutools > Merge & Split > Combine Rows, Columns or Cells without Losing Data. Full feature free trialģ0-day, no credit card required! Get It Nowġ. Note: You can find the complete documentation for the CONCAT function in Excel here.For example, you have a range as below screenshot shown, you can concatenate this range into one column, one row, or one cell easily with Kutools for Excel’s Combine utility.ģ00 handy tools for Excel. Notice that the value in cell C2 is the result of concatenating every value in column A where the corresponding value in column B is equal to “Good.” We can use the following formula to concatenate all of the cells in column A where the value in column B is equal to “Good”: =CONCAT(IF( B2:B7="Good", A2:A7, "")) Once again suppose we have the following data in Excel:
Otherwise, this formula simply returns a blank value. If the cell in column B is equal to “Good” then the value in column C is equal to the concatenation of the cells in column A and B. The following screenshot shows how to use this formula in practice: We can use the following formula to concatenate cells in column A and B only if the value in column B is equal to “Good”: =CONCAT(IF( B2="Good", A2:B2, "")) Suppose we have the following data in Excel: The following examples show how to use a concatenate if formula in Excel.
0 kommentar(er)
