If you have columns that you need to split by an equal number of characters, say ID numbers then it will be helpful for you.
For this tutorial, I have the following set of data that is given below. Now, I want to split this data by 3 characters so that I will have 3 parts of each serial code.
Here are the steps given below to follow in your Excel:
STEP1: Insert Table
first you need to convert your data into Excel Table so for that select your data and press the shortcut Ctrl + T or go to Insert > Table. It will easily turn your data into Excel Table.
STEP2: Open Power Query
If you are using Excel 2016:
Go to Data > From Table (Under Get & Transform)
Or if you are using Excel 2013 & 2010:
Power Query > Excel Data > From Table
STEP3: Split The Columns
After following them you will see a Power Query Editor on your screen. So, now you need to select the column you want to split here.
After selecting the column follow this:
Go to Home > Split Column > By Number of Characters
At last to open a new worksheet in your Excel workbook, Click Close & Load from the Home tab and this will open with the updated table.
There you go with your separated columns in new table.