Flash Fill

GPTKB entity

Statements (35)
Predicate Object
gptkbp:instanceOf Microsoft Excel feature
gptkbp:activatedBy Data tab in Excel ribbon
keyboard shortcut Ctrl+E
gptkbp:availableOn gptkb:Microsoft_Excel
gptkbp:canBeDisabled Excel options
gptkbp:canExtract dates
numbers
custom text patterns
first names
last names
gptkbp:category data manipulation
productivity tool
gptkbp:compatibleWith gptkb:Excel_Online_(limited_support)
gptkb:Excel_for_Mac_(before_2016)
gptkbp:developer gptkb:Microsoft
gptkbp:documentation gptkb:Microsoft_Support_website
gptkbp:example combining columns
formatting phone numbers
splitting full names
gptkbp:function automatically fills in values based on patterns
https://www.w3.org/2000/01/rdf-schema#label Flash Fill
gptkbp:introducedIn gptkb:Microsoft_Excel_2013
gptkbp:limitation does not update dynamically
may not recognize complex patterns
not formula-based
gptkbp:operates columns
gptkbp:relatedTo gptkb:Power_Query
Excel formulas
Text to Columns
gptkbp:requires at least one example
gptkbp:status enabled
gptkbp:uses pattern recognition
gptkbp:bfsParent gptkb:Microsoft_Excel
gptkb:Sumit_Gulwani
gptkbp:bfsLayer 6