How to Split Cells Using Text to Columns Wizard in Excel
Step 1: Select the entire data set [Range A1 – A11]
Step 2: Go to “Data” >> Click “Text to Columns”, to pop up Convert Text to Columns Wizard
Step 3: Select “Delimited” and Press “Next”
Step 4: Check “Space” and Press “Next”
Step 5: Change Destination to $B$1 cell and Press “Finish”
Output: We have achieved split cells in Excel.
How to Split Cells in Excel: In 5 Easy Steps
Microsoft Excel is a powerful data tool used in various industries. Organizing data in separate cells is crucial for clarity and analysis. We often receive data with many points in one cell due to different initial purposes.
In these situations, we frequently divide a cell into its component pieces. In this article, we will learn how to split cells in Excel using formulas, shortcut Keys, and more.