Text Functions
Beginner
CONCAT Function
Use CONCAT to join multiple text values together.
Task:
Create email addresses by combining first name, last name, and domain. Use CONCAT with LOWER to generate standardized email format.
Learning Objectives:
- Learn CONCAT function
- Understand advanced text joining
- Practice combining functions
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | First Name | Last Name | Domain | |
| 2 | John | Smith | company.com | |
| 3 | Jane | Doe | company.com | |
| 4 | Mike | Johnson | company.com |
What this exercise teaches (contains the answer)
CONCAT is a newer function that joins text strings. It can accept ranges, making it more flexible than CONCATENATE or the & operator.