You have been given the task: to create an accounting table of all workers of the enterprise using the Microsoft Office Excel spreadsheet editor. Before creating the table, you counted the required number of columns and created it. But your boss demanded that you divide one column "Surname First name Patronymic" into 3 components. In order to split a cell as quickly as in MS Word, read the rest of the article.
Necessary
Microsoft Office Excel software
Instructions
Step 1
Let's continue working with our table, in which it is necessary to change the value of the column "Surname First Name Patronymic". You need to make from the meaning "Petrov Petr Petrovich" - "Petrov", "Peter" and "Petrovich". Click on the cell you will be breaking up.
Step 2
In the main menu of Microsoft Excel, select the "Data" tab - go to the "Working with data" group - select the "Text by Columns" item.
Step 3
In the "Text wizard (parsing) - step 1 of 3" window that appears, go to the "Source data format" group - then select the "Delimited" add-in - click the "Next" button.
Step 4
In the window "Text wizard (parsing) - step 2 of 3" go to the group "The symbol is a separator" - check the box next to the item "space" (Here you need to select the symbol that separates the words in the cell that we want to break. case, such a character is a space). After completing these steps, click the Finish button.
Step 5
The settings window will close, view the result of the work. If the cell was split incorrectly, undo the last actions (by pressing the keyboard shortcut Ctrl + I) and try again to perform this operation.
Step 6
As a result of the actions performed, you have received a division of the cell into separate parts, based on the specified parameters.
