=IFS( logical_test1, value_if_true1,, …) Select the range of cells that you want to combine together =CONCAT( C9:E9)Īpply the same formula to the rest of the cells by dragging the lower right corner downwards.Ĭhecks multiple conditions and returns the value of the first TRUE condition Which cells do you want to combine together?
STEP 1: We need to enter the CONCAT function in a blank cell: =CONCAT(
