You're a privacy analyst exporting an employee directory to a third-party vendor. The vendor's contract permits the first name in full but only the first initial of the last name for any record they retain. You have 12 employees in column A (Full Name) as "First Last" (single space, no middle names).
Example: "Sarah Smith" → "Sarah S." (note the trailing period).
Your task:
- In column B (Anonymized), write a formula that returns the anonymized form for each name.
- The formula must drag-fill from B2 → B13.
The pattern uses FIND once to locate the space, then slices around it. =LEFT(A2, FIND(" ", A2)+1) & "." reads as: take everything from the start through the first character of the last name (LEFT to position-of-space + 1), then append a period. The result is exactly what the vendor's spec requires.
Graded cells: B3 (Mark Johnson → Mark J.), B7 (James Chen → James C.), B9 (Michael Garcia → Michael G.).
Open this problem on a desktop to attempt it.