Goal: Combine First Name, Middle, and Last Name.
CONCAT: Glues text directly.
TEXTJOIN: Adds a separator (e.g., space) automatically.
(Waiting to join...)
Ready...
💻 Formula Structure
=CONCAT(text1, [text2], ...)
- 1. Text: Strings to combine.
- Note: Does not add spaces automatically. You must include them manually as " ".
=TEXTJOIN(delimiter, ignore_empty, text1...)
- 1. Delimiter: Separator (e.g., " ").
- 2. Ignore Empty: TRUE/FALSE. Skips blanks.
- 3. Text: The strings to join.
-- Select a function...
...
⚠️ Common Pitfalls
🚫 Concatenate vs Concat
CONCATENATE is the old legacy function. CONCAT is the modern version that supports ranges (e.g. A1:A10), which the old one couldn't do.
🚫 Missing Spaces
=CONCAT("John", "Doe") results in "JohnDoe". Always remember to add the space: =CONCAT("John", " ", "Doe").