How to Use Flash Fill in Excel
HTML-код
- Опубликовано: 15 июл 2024
- Learn how to use Flash Fill in Excel to quickly reformat data without formulas. Examples include separating last names and first names, fixing capitalization, combining data from multiple columns, removing extra spaces, and separating parts of addresses.
Reminder: The Flash Fill keyboard shortcut is CTRL+E
0:00 Getting last names and first names from a list
1:24 Reformatting in one step (and
1:59 Fix capitalization (compared to the PROPER function)
2:29 Remove extra spaces (compared the TRIM function)
3:24 Combine columns (compared to the CONCAT function)
4:17 Separate parts of addresses
👍 Remember to Subscribe!
WATCH HOW TO USE AUTOFILL:
• How to Use AutoFill in...
SONG CREDIT: Ocean Ave, by J.A.K (Jon Are Kulsveen)
FOLLOW VERTEX42 HERE:
Instagram: / vertex42
Facebook: / vertex42
Pinterest: / vertex42
Twitter: / vertex42
Website: www.vertex42.com/
I feel like I have just learned what the wheels are for on a bike! Wow. Thanks
AWESOME tutorial (especially demonstrating "mistakes" that happen, and your pace was perfect for me). What a time-saving tip!! I'm rusty on Excel... learned it 20+ years ago and don't need it much, so this was brilliant. I almost never leave comments on RUclips. You deserve for this to be seen and shared. Thank you!! (btw, I like your templates too!)
Thank you for the AWESOME tutorial !!!!
Terrific - tks from Brazil
Wow you do great videos!
Impressive!
How did you put those comments in your video?
Used Camtasia for these videos.
I have a file with a table that has a lot of conditional formulas,
If flash fill is enabled after every cell input excel hangs 20 -30 seconds. So I keep this function disable.
Interesting. I need to test that with one of my files.
is a known issue unfortunately stackoverflow.com/questions/28563761/excel-freezes-while-entering-data