In this video learn how to rearrange a product code using Excel Spreadsheet Functions and Power Query Functions. Also see that Flash Fill does not seem to work. Learn the Power Query equivalent for LEFT, RIGHT and MID Functions.
(01:36) See an example of Flash Fill and how it does not seem to work
(03:04) See Excel Spreadsheet Formula that uses the Functions MID, RIGHT and LEFT.
(06:07) See Power Query (M Code Functions) Custom Column Formula that uses the Functions Text.End, Text.Middle and Text.Start.