Miracle of Flash Fill - Separate Names with Keyboard Shortcuts Customer lists with full names in one column can slow down your analysis and make reports messy. Instead of building formulas with LEFT, RIGHT, or TEXT, use Excel’s hidden speed tool: Ctrl E. This Keyboard shortcut activates Flash Fill, which learns your pattern from one example and instantly completes the rest of the column. How it works? Full names in Column A (Alex Johnson, Maria Garcia). In Column B, type the first name once → pr

Flash fill can automatically fill your data when it identifies a pattern. Watch this tutorial video, learn how to input data in a convenient way! Shortcut key for flash fill: CTRL E WPS Office: https://bit.ly/3ewm8OV YouTube: https://youtu.be/EF6Trfr1DPg #officetool #ppt #pdf #word #excel #txt #picture #easy #efficient #work #workfromhome #efficiency #wpsoffice #professional #independent #theoffice #worktools | WPS Office