← All exercises

CONCAT — First + last name

Joining Last name + First name

Combine last name and first name into one cell using &, CONCAT and TEXTJOIN, with UPPER/LOWER for formatting — 6 guided steps.

=cell & " " & cell

1 / 6

Join first name + space + last name

=CONCAT( … , " " , … )

2 / 6

Same thing with CONCAT

=UPPER(…) & " " & …

3 / 6

Format "LAST NAME First name" (last name in uppercase)

="Hello Mr. " & cell

4 / 6

Greeting line: "Hello Mr. Dupont"

=TEXTJOIN( delimiter , ignore_empty , … )

5 / 6

Join Last name, First name and City with TEXTJOIN

=LOWER( … & "." & … & "@company.com" )

6 / 6

Build an email: firstname.lastname@company.com

Your score is

0%