Home Sample Files e-Books Books Wholesale Forums & Support Search Contact
Login
Basic Skills
Essential Skills Expert Skills Construction Kits
2016 2013 2010 2007 Apple Mac

Use manual Flash Fill to split text:

Lesson 2-20 from: Microsoft Excel 2016 Basic Skills (39 Video Lessons)
This video walkthrough does not have voice narration. It is intended to be used as a supplement to the printed book or e-book.
Click the Read E-Book Lesson button below to open the e-book version of this lesson.
Use manual Flash Fill to split text
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Before you watch your first video you need to know three things!
1. This is a walk-through and not a stand-alone video lesson
The walk-through is intended to be used only with an e-book or paper book. Read and work through the printed lesson first. Only watch the video walk-through if you have difficulty with it.
2. Video walk-throughs do not have a sound track
Reading out the lesson steps (shown in the captions) wouldn't add any value. If a wordy narrative was added it would bloat the walk-through and make it less useful for its intended purpose.
3. Make sure that you use the interactive transcript and e-book button
Jump straight to the step you need to see using the interactive transcript. window. Just click on the step you need. Play with the other buttons too - you'll never have seen some of the features our player has before.
OK - I’ve got it! Don't show this again.
Play
Back 10 Seconds
Slower
Faster
Full Screen View
Online Video Course: Microsoft Excel 2016 Basic Skills
Session: Session 2: Doing Useful Work with Excel
Lesson: Lesson 2-20 Use manual Flash Fill to split text Excel Flash Fill manual split text. Thumbnail from Excel 2016 Essential Skills Lesson 2-19 Use manual Flash Fill to split text.
Description:

Flash Fill is used in this video lesson to split text. This lesson uses Manual Flash Fill rather than Automatic Flash Fill enabling you to split text and numbers in a more sophisticated way. You are going to use Excel 2016's new Flash Fill feature to split the Country Code, Area Code and Number from a USA telephone number. You'll also learn the advantages and disadvantages of using Flash Fill instead of a formula-based solution.

Share on Facebook
Share on Twitter
Share on Google+
Share on Reddit
Share on Tumblr
Share on StumbleUpon
Share by email