Merging columns

%3CLINGO-SUB%20id%3D%22lingo-sub-1637756%22%20slang%3D%22en-US%22%3EMerging%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1637756%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20I%20am%20trying%20to%20merge%204%20columns%20(address%2C%20city%2C%20state%20and%20zip%20code)%20into%20one%20column....how%20do%20I%20do%20this%3F%26nbsp%3B%20I%20tried%20merge%20and%20center%20but%20it%20deleted%20my%20data.%26nbsp%3B%20Any%20help%20would%20be%20appreciated!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1637756%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1637790%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1637790%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F782907%22%20target%3D%22_blank%22%3E%40catcremo%3C%2FA%3E%26nbsp%3BLook%20into%20functions%20like%20CONCATENATE%2C%20CONCAT%20or%20TEXTJOIN%2C%20depending%20on%20the%20Excel%20version%20you%20are%20working%20with.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi I am trying to merge 4 columns (address, city, state and zip code) into one column....how do I do this?  I tried merge and center but it deleted my data.  Any help would be appreciated!

1 Reply
Highlighted

@catcremo Look into functions like CONCATENATE, CONCAT or TEXTJOIN, depending on the Excel version you are working with.