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
|