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

No login or Excel install required
# 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.

Start free training academy

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.

Open Excel Practice Gym

Deskademy Assistant

Thinking…