In Google Sheets, you can split a full name into first and last names using formulas. Assuming the full name is in column A, here's a simple method:
- Assuming the full name is in cell A1:
- In cell B1, you can use the formula =SPLIT(A1, " ", TRUE, TRUE) to split the full name into separate columns based on the space.
- This formula uses the SPLIT function, which divides a text string into separate substrings based on a specified delimiter. In this case, the delimiter is a space (" "), and TRUE, TRUE ensures that any extra spaces are also considered.
- Drag this formula down for the entire column if you have multiple names.
- Click on the bottom right corner of the cell (fill handle) in cell B1 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.
Alternatively, you can use formulas like =INDEX(SPLIT(A1, " "), 1) for the first name and =INDEX(SPLIT(A1, " "), 2) for the last name. These formulas use the INDEX function to extract the specific part of the split name.
Choose the method that best fits your preference or specific use case.
