Stitch first + last names into one column for the mailout
HR is prepping the holiday card mailing list. First names sit in column A, last names in column B, but the print template needs them joined into one "Full Name" field. Build the join in C2 and drag it down to cover every employee.
Build employee full names
Practice using CONCAT to solve a real hr & operations problem. By the end, you’ll know when to reach for it and how to structure the arguments correctly.
HR needs to generate a mailing list. First names are in column A and last names in column B. You need to combine them into full names with a space in between.
In C2, join the first name in A2 with the last name in B2 and put a space between them. Either CONCAT or the & operator works.
CONCAT joins text from multiple cells or ranges into one string. The modern replacement for CONCATENATE: same job, but CONCAT accepts ranges (CONCAT(A2:A6)) where CONCATENATE only accepts individual cells. For delimiters or skip-empty support, use TEXTJOIN instead.
CONCAT(text1, [text2], ...)Try the formula first. Hints cost CP for a reason.