Combine data from 2 columns into 1 column

Occasional Visitor

I want to do this, but with 2 columns of data.  We have a sheet with area codes in one field and phone numbers in another.  I need the 2 pieces of data in one field for a list of 500 phone numbers.  Do I have to do them one at a time????

Combine data with the Ampersand symbol (&)

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

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

  3. Type & and use quotation marks with a space enclosed.

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

3 Replies

Use your formula in the initial cell and then drag the formula down to the last row. Put your cursor in the bottom right corner of the cell until it changes into a cross (+) and then click and drag to the bottom.

Or enter your formula into the first cell, select entire column range includes that cell and Ctrl+D