Home

Merging two row cells and repeating down a column (not down a row).

%3CLINGO-SUB%20id%3D%22lingo-sub-360080%22%20slang%3D%22en-US%22%3EMerging%20two%20row%20cells%20and%20repeating%20down%20a%20column%20(not%20down%20a%20row).%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360080%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20an%20excel%20file%20of%20contact%20names.%20The%20first%20name%20is%20in%20one%20cell%20(Cell%20A)%20and%20the%20last%20name%20is%20in%20a%20separate%20cell%20(Cell%20B).%20They%20are%20in%20the%20same%20row.%20I%20have%20over%201600%20contact%20names%20(or%20rows)%20like%20this.%20I%20want%20the%20first%20and%20last%20names%20to%20be%20merged%20with%20one%20another%20in%20just%20one%20cell.%20How%20do%20I%20do%20this%20in%20the%20quickest%20and%20simplest%20way%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-360080%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-732822%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20two%20row%20cells%20and%20repeating%20down%20a%20column%20(not%20down%20a%20row).%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-732822%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F295088%22%20target%3D%22_blank%22%3E%40kasimley%3C%2FA%3E%26nbsp%3B%20In%20C1%20enter%3A%20A1%26amp%3B%22%20%22%26amp%3BB1%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-360093%22%20slang%3D%22en-US%22%3ERe%3A%20Merging%20two%20row%20cells%20and%20repeating%20down%20a%20column%20(not%20down%20a%20row).%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-360093%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20are%20on%20Excel%202013%20or%20later%20Flash%20Fill%20could%20be%20the%20easiest%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fusing-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fusing-flash-fill-in-excel-3f9bcf1e-db93-4890-94a0-1578341f73f7%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
kasimley
New Contributor

I have an excel file of contact names. The first name is in one cell (Cell A) and the last name is in a separate cell (Cell B). They are in the same row. I have over 1600 contact names (or rows) like this. I want the first and last names to be merged with one another in just one cell. How do I do this in the quickest and simplest way?

2 Replies