Merge existing cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2021480%22%20slang%3D%22en-US%22%3EMerge%20existing%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2021480%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3EI%20have%20an%20address%20book(10%2C000%2B%20lines)%20and%20I%20need%20to%20merge%20E%2C%20F%2C%20G%2C%20H.%20(Address%2C%20city%2C%20state%2C%20zipcode)%20into%20one%20cell%20and%20keep%20all%20existing%20data...%20suggestions%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2021480%22%20slang%3D%22en-US%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-2021516%22%20slang%3D%22en-US%22%3ERe%3A%20Merge%20existing%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2021516%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F913897%22%20target%3D%22_blank%22%3E%40Christmaspianogirl81%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20choose%20to%20use%20CONCATENATE%20function%20or%20PowerQuery.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DCONCATENATE(E2%2C%22%20%22%2CF2%2C%22%20%22%2CG2%2C%22%20%22%2CH2)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor
Hello,
I have an address book(10,000+ lines) and I need to merge E, F, G, H. (Address, city, state, zipcode) into one cell and keep all existing data... suggestions?
1 Reply

@Christmaspianogirl81 

You can choose to use CONCATENATE function or PowerQuery.

=CONCATENATE(E2," ",F2," ",G2," ",H2)