Excel CONCAT to T-SQL CONCAT

The names match. The NULL rules do not always. Test a NULL middle name once.

CONCAT(first_name, ' ', last_name)

A trailing space when last_name is NULL: wrap parts in NULLIF or use a CASE.

Canonical translation

CONCAT(first_name, ' ', last_name)