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.