Question

how to combine values in multiple cells into one cell

Answer 1

Answer:

Combine text from two or more cells into one cell

Select the cell where you want to put the combined data.

Type = and select the first cell you want to combine.

Type & and use quotation marks with a space enclosed.

Select the next cell you want to combine and press enter.

An example formula might be =A2&" "&B2.

Answer 2

Answer:

Combine text from two or more cells into one cell

Select the cell where you want to put the combined data.

Type = and select the first cell you want to combine.

Type & and use quotation marks with a space enclosed.

Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.