45 seconds Interactive Fix
Excel
Verified Office Standard
How to Combine First and Last Name in Excel (&, CONCAT, TEXTJOIN)
HR exports frequently separate candidate first and last names across two columns. Reports require a unified Full Name.
Live browser simulator
Solve it right now
| # | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | ||
| 2 | Sarah | Jenkins | Fixed | ||
| 3 | Marcus | Vance | |||
| 4 | |||||
| 5 | |||||
| 6 | |||||
| 7 |
Want to test your skills across 100+ workplace scenarios?
Deskademy simulates real office software with instant grading, hints, and certified CV credentials.
Step-by-step instructions
1
Use Ampersand with Space
In cell C2, type: =A2 & " " & B2.
2
Alternatively use TEXTJOIN
Type: =TEXTJOIN(" ", TRUE, A2, B2).
3
Autofill Downwards
Double click the fill handle to apply the formula down all rows.
500+ repeated drills
Master Excel in the Deskademy Gym
Drill 10+ repeated variations on this exact topic until it becomes second nature for your next job interview.
More fast office problem fixes
How to Fix #N/A Error in Excel Lookups (IFERROR & XLOOKUP)
→
How to Sum with Multiple Conditions in Excel (SUMIFS Syntax Guide)
→
How to Remove Duplicate Rows in Excel Without Losing Data
→
How to Calculate Average in Excel Ignoring Zeros (AVERAGEIF)
→
How to Extract a ZIP Archive in Windows 11 File Explorer
→
How to Standardize File Names with ISO 8601 Date Format (YYYY-MM-DD)
→
How to Spot and Report a Phishing Email in Microsoft Outlook
→
How to Use CC vs. BCC Correctly in Corporate Email
→
How to Apply Heading 1 and Heading 2 Styles in Microsoft Word
→
How to Center and Align Tables in Microsoft Word Documents
→
How to Redact PII (Personally Identifiable Info) Before Prompting Workplace AI
→