Forum Discussion
Is there a function to agregate 2 columns keeping datas from both?
Hi everybody 🙂
I saw there's a function that allows to split 1 column into 2, separating the datas you want to be parted. Is there the opposite function ? Meaning : I want to agregate (without any separation) the datas of 2 different columns. In this case, one column contains id numbers, the other one an extension to an email adress (@........).
Could anybody be so helpful and answer me ?
Thank you so much
Let's say the data are in columns A and B, starting in row 2.
Enter the following formula in a cell in row 2, for example in C2:
=A2&B2
Fill or copy down.
3 Replies
Let's say the data are in columns A and B, starting in row 2.
Enter the following formula in a cell in row 2, for example in C2:
=A2&B2
Fill or copy down.
Thank you very much Hans for that swift answer ! I try this immediately !
