CONCAT Function - Free Excel Practice Online

This free, interactive exercise teaches you CONCAT Function in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Text Manipulation Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising CONCAT Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this CONCAT Function lesson

1. Join two or more strings of text together with the CONCAT function. Type =CONCAT(A1, B1) to return "ABCD".
2. The concat function can have as many arguments as you'd like. Use concat to get the person's full name. (Hint: don't forget the spaces - your function should have five arguments!)
3. You can also use the ampersand (&) to concatenate strings. Type =A1&", "&A2 to return "Minneapolis, Minnesota".
4. Use the concat function to return "JSmith@example.com"
5. Use & to return a string that says "Hello world".
6. Use the concat function to return a string that says "Hello, Eric" (don't forget the comma and space!)
7. Use & to return "ABCDEFG"
8. Use & to combine the pieces to form www.somedomain.com.
9. Use & to return the string "Biscuits & gravy".
10. Use the concat function to return the phone number 651-555-5816.

CONCAT Function practice - FAQ