Microsoft Excel tutorial: Combine/ Concatenate/ cells, Reverse Concatenate / split cell, find repeats/duplicates
Combine data/ Concatenate (merge) cells in Excel spreadsheets: 1. Combine two cells A and B (First name and Last name) 2. Paste =CONCATENATE(A3, " ", B3) in C3 3. Click enter and drag to C13 Reverse Concatenate or split cell text into separate columns 1. Choose the right column or cells. Here Full name column A3 to A11 2. Click on Data tab in the File, Home row 3. Click on Text to Columns 4. Click on Convert Text to Columns Wizard 5. Click on Delimited (or Fixed Width as per requirement) 6. Click on Next. 7. Choose the appropriat...