00:00 Split columns by required width of column (first 6 characters etc.) in PQ
00:20 Load single column into PowerQuery
00:29 Power Query loses leading zeros when importing data
00:35 Split columns by number of characters
00:44 Number of characters for the first column split
00:54 Repeat the SAME number of character splits OR only left characters OR only right characters
01:16 Undo the change type to keep the leading zeros
01:22 Check PowerQuery cell for leading/ trailing spaces
01:45 TRIM spaces to remove leading/ trailing spaces

How to split a column in Excel's PowerQuery based on the number of characters (a fixed width file typically downloaded from older computer systems). You can specify the number of characters to use and also whether it should repeat the numbers (e.g. first 6 characters, then next 6 characters, then next 6 characters etc.), or just the first 6 characters or the last 6 characters (very useful).

свернуть