Google Sheets overrides the original data. If you want to use full names later, copy the rows, paste them to another column or sheet, and run the Split text to columns function.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF () function. Here's how.