Select the cell where you want to put the combined data.
Type = and select the first cell you want to combine.
Type &, add quotation marks ” “ with a space enclosed, then type another & after the quotation marks.
Select the next cell you want to combine and press enter. An example formula might be =A2&” “&B2.
To combine the text in more than two cells, continue selecting cells, and typing &" "& after each selected cell. If you don’t want any space between the combined text, just type & instead of &" "&. To add a comma, type &”, “&.
