Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

Excel Magic Trick 1475: Power Query, Formula, Flash Fill: “1-PSD/AFX-12” into “12-AFX/PSD-1”

Posted on by Annie D

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

View on YouTube

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.