In Numbers, you can split a full name into first and last names using the following steps:
- Assuming the full name is in column A:
- In cell B1, you can use the formula =LEFT(A1,FIND(" ",A1)-1) to extract the first name.
- In cell C1, you can use the formula =MID(A1,FIND(" ",A1)+1,LEN(A1)) to extract the last name.
- Drag these formulas down for the entire column if you have multiple names in column A.
- Click on the bottom right corner of the cell (there should be a small square, called the fill handle) and drag it down to fill the cells in the column.
Now, column B will have the first names, and column C will have the last names.
Note: These formulas assume that there is a space between the first and last names. If the names are formatted differently, you might need to adjust the formulas accordingly.
