Forum Discussion
Combine data from 2 columns into 1 column
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. ...
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