How to Split Cells Using Power Query in Excel
Excel’s Power Query feature can also be used to divide several cells. It has been natively available since Excel 2016.
Let’s start off with adding our data cells into the Power Query editor. The steps to take are listed below,
Step 1. Click Data tab > From Table/Range after choosing any cell from the data set
Step 2. Make sure the “My table has headers” option is checked, and the whole range is selected. Then press OK.
Step 3. All the data will be visible when the Power Query editor opens
Step 4. Select Home > Split Column (drop-down) > By Delimiter from the Power Query ribbon
Step 5. The Space character and At each occurrence of the delimiter are both suitable choices for our circumstances. Select OK
Step 6. The Employee name column is now divided into two distinct columns in the data preview pane. To change the headings to First name and Last name, double-click the header and make changes respectively
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.
Contact Us