How to merge first and last name into full name
Your data has names split across columns but you need a single full name field for labels, emails, or exports.
See it in action
Prompt
"Merge first_name and last_name into a full_name column"
Before
| # | first_name | last_name | company | |
|---|---|---|---|---|
| 1 | Sarah | Johnson | sarah@email.com | Acme Inc |
| 2 | Michael | Chen | mchen@work.co | Tech Corp |
| 3 | Emily | Watson | ewatson@med.org | City Hospital |
After
| # | full_name | company | |
|---|---|---|---|
| 1 | Sarah Johnson | sarah@email.com | Acme Inc |
| 2 | Michael Chen | mchen@work.co | Tech Corp |
| 3 | Emily Watson | ewatson@med.org | City Hospital |
Why use Magic CSV for this?
- Combine first, middle, and last names
- Add proper spacing automatically
- Perfect for mail merge and labels
Related guides
- Merge Columns Together
Combine any columns with custom separators
Ready to transform your data?
Upload your CSV, describe what you want, get clean data back.