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. ...
Doesn't work. Example?radfordsix
SergeiBaklan 1. Here is my error
You can see the formula just doesn't work. Yes, I do have automatic calculations selected.
2. The example link you provided also doesn't work. Yes, my internet is fine (or I wouldn't be able to post this comment).
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)
