SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1615821%22%20slang%3D%22fr-FR%22%3EIs%20there%20a%20function%20to%20agregate%202%20columns%20keeping%20datas%20from%20both%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1615821%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%20everyone%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20I%20saw%20there's%20a%20function%20that%20allows%20to%20split%201%20column%20into%202%2C%20separating%20the%20data%20you%20want%20to%20be%20parted.%20Is%20there%20the%20opposite%20function%3F%20Meaning%3A%20I%20want%20to%20agregate%20(without%20any%20separation)%20the%20datas%20of%202%20different%20columns.%20In%20this%20case%2C%20one%20column%20contains%20id%20numbers%2C%20the%20other%20one%20an%20extension%20to%20an%20email%20address%20.%20.%20.%20%3CBR%20%2F%3E%20Could%20anyone%20be%20so%20helpful%20and%20answer%20me%3F%20%3CBR%20%2F%3E%20Thank%20you%20so%20much%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1615821%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1615838%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20there%20a%20function%20to%20agregate%202%20columns%20keeping%20datas%20from%20both%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1615838%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F773099%22%20target%3D%22_blank%22%3E%40Leovaly%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20the%20data%20are%20in%20columns%20A%20and%20B%2C%20starting%20in%20row%202.%3C%2FP%3E%0A%3CP%3EEnter%20the%20following%20formula%20in%20a%20cell%20in%20row%202%2C%20for%20example%20in%20C2%3A%3C%2FP%3E%0A%3CP%3E%3DA2%26amp%3BB2%3C%2FP%3E%0A%3CP%3EFill%20or%20copy%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1615843%22%20slang%3D%22fr-FR%22%3ERe%3A%20Is%20there%20a%20function%20to%20agregate%202%20columns%20keeping%20data%20from%20both%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1615843%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3EVogelaar%20%40Hans%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20very%20much%20Hans%20for%20that%20quick%20answer!%20I%20try%20this%20immediately!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1615874%22%20slang%3D%22fr-FR%22%3ERe%3A%20Is%20there%20a%20function%20to%20agregate%202%20columns%20keeping%20data%20from%20both%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1615874%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3EVogelaar%20%40Hans%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20wonderful!%20You%20saved%20my%20day%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies
Best Response confirmed by Leovaly (New Contributor)
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.

@Hans Vogelaar 

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

@Hans Vogelaar 

Just wonderful ! You saved my day