Data should be combined with the Ampersand symbol (&).
Choose the cell where you wish the combined data to go.
Enter = and choose the first cell to merge.
Enter & and a space between the quotation marks.
Choose the next cell to merge and click enter. As an example, consider the formula =A2&” “&B2.