The need to concatenate two Excel columns together usually comes when a file you want to import has the phone number broken down into two columns with the area code in one column and the phone number in another. To combine the two values into one column in Excel:
- Go to the first empty column and enter a header for the phone number in 1st row
- Place curser in 2nd row of the column and enter formula as: =(Cell1&Cell2) replacing Cell1 and Cell2 with the appropriate cell numbers.
- Copy the formula all the way down the column