User level: Level 1 (4 points)I have an exported spread that has a column with full names. Is there a function in Numbers that can help me format "first name last name" to "first initial last name"?
Posted on Sep 19, 2026 2:35 PM
User level: Level 6 (12,236 points)Sep 19, 2026 3:13 PM in response to SupportIt09
Yes. If the full name is in A2 and the names are consistently in First Last format, try:
=LEFT(A2,1)&" "&RIGHT(A2,LEN(A2)-FIND(" ",A2))
So John Smith becomes J Smith.
If you want J. Smith instead, use:
=LEFT(A2,1)&". "&RIGHT(A2,LEN(A2)-FIND(" ",A2))
Then fill the formula down the column.
This assumes each entry has just a first and last name. If some include middle names, the formula would need a small adjustment.
Originally posted at discussions.apple.com/thread/256360759