Practice / Text

Difficulty 2 of 5 · about 3 min

Split a full name into first and last name

Column B holds employee full names written as first name, a space, then last name. In C2, write one formula that splits the name in B2 so the first name lands in C2 and the last name lands in D2. Do not type anything in D2. Use SPLIT.

Loading grid…