If a name has multiple words, such as a middle name or a hyphenated last name, include them in the formula with the desired separator. For example, if the name is 'John William Smith,' use the formula '=CONCAT(A2," ",B2," ",C2)' to combine the first, middle, and last name.