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. ...
As I understood actually the question was why in D2 is =A2&" "&B2, not the resulting text. In your case in the cell will be =CONCAT(B2," ",C2)