Is there a function to agregate 2 columns keeping datas from both?

[Leovaly]

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

[#2 · Accepted solution]

@Leovaly 

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]

@Hans Vogelaar 

Thank you very much Hans for that swift answer ! I try this immediately !

[#4]

@Hans Vogelaar 

Just wonderful ! You saved my day :)