Splitting full names into separate columns is a common task for data cleaning. You can use the built-in Text to Columns tool for a quick fix or formulas for dynamic updates.
AI에게 맡기기Select the data range
Highlight the cells containing the full names you want to split.
텍스트 나누기 열기
Go to the 'Data' tab on the ribbon and click 'Text to Columns'.
Configure the wizard
Choose 'Delimited', click 'Next', check the 'Space' box, and click 'Finish'.
=LEFT(A2, FIND(" ", A2)-1) & " " & RIGHT(A2, LEN(A2)-FIND(" ", A2))Text to Columns will split every word separated by a space into a new column.