Home Sample Files Register Books and e-books Forums Support Contact Search
Login
Basic Skills
Essential Skills Expert Skills
Excel 2016 Excel 2013 Excel 2010 Excel 2007

Use manual Flash Fill to split text (Excel 2013):

Lesson 2-19 from: Microsoft Excel 2013 Basic Skills (41 Video Lessons)
Use manual Flash Fill to split text
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Play
Back 10 Seconds
Slower
Faster
Full Screen View
Online Video Course: Microsoft Excel 2013 Basic Skills
Session: Session 2: Doing Useful Work with Excel
Lesson: Lesson 2-19 Use manual Flash Fill to split text Excel Flash Fill manual split text. Thumbnail from Excel 2013 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 2013'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