Hey Friends,
Welcome back to the Sheet! Today’s Excel tip is relatively well-known, but is a complete game-changer for those who don’t - potentially saving you hours of work!
📋 Summary:
💡 The Sheet Tip (Flash Fill ⚡️)
📚 What We're Reading: Sloww.co
=💡 The Sheet Tip (Flash Fill ⚡️)
Have you ever found yourself spending valuable time manually editing and formatting data in Excel? Say goodbye to tedious data transformations with the magic of Flash Fill! This powerful feature in Excel automates the process of extracting, rearranging, and formatting data based on patterns it detects.
To use Flash Fill, simply follow these steps:
Enter a sample value in the desired format in a new column.
Press CTRL+E in the cell below, and Excel will automatically fill in the remaining values based on the detected pattern.
Here’s an example: Extracting first names from full names
Enter a few full names in one column (e.g., "John Doe").
In the adjacent column, start typing the desired format for the first name (e.g., "John").
In the cell below hit CTRL+ E and Excel will recognize the pattern and automatically fill in the remaining first names.
Check out our TikTok video to see this in action (Click here)
Other useful scenarios you can utilize Flash Fill:
Splitting combined data into separate columns e.g. “London, UK” to “London”
Formatting Dates e.g. “01/01/2023” to “January 1, 2023”
📚 What We're Reading: Sloww.co
If you’re anything like us, life can sometimes feel like an uphill battle with never enough time to complete the endless array of tasks at work and at home. Sloww.co has been helping us to take a moment to pause, and focus on what’s important.
Sloww.co is a blog dedicated to exploring the art of slow living and lifelong learning. The blog offers insightful articles, book summaries, and resources to help readers embrace a slower, more meaningful approach to life. With a focus on topics like minimalism, mindfulness, personal growth, and productivity, Sloww.co encourages readers to pause, reflect, and make intentional choices that align with their values and aspirations. The blog aims to inspire and empower individuals to create a simpler, more intentional life that is filled with purpose, joy, and fulfillment.
If you’re interested in learning more click the link below to get started:
Thanks for reading. If you found it useful, please hit that like button and share it with a friend or colleague.
See you next week.
The Functional Excel Team