Download Files: Start Excel File: http://ift.tt/2q2E39T
Download Files: Finished Excel File: http://ift.tt/2EnqTHt
Entire page with all Excel Files for All Videos: http://ift.tt/1zHY6GI about how to
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.
Topics:
Topics:
1. (00:11) Introduction
2. (01:36) See an example of Flash Fill and how it does not seem to work
3. (03:04) See Excel Spreadsheet Formula that uses the Functions MID, RIGHT and LEFT.
4. (06:07) See Power Query (M Code Functions) Custom Column Formula that uses the Functions Text.End, Text.Middle and Text.Start.
5. (10:33) Summary