Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel ROW Function
  • Count unique text values with criteria
  • Count rows that contain specific values in Excel
  • How to use Excel INDIRECT Function
  • Two-column Lookup in Excel

Data Analysis Examples

  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • How to Create Area Chart in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How to count table rows in Excel
  • How To Load Analysis ToolPak in Excel

Data Validation Examples

  • Excel Data validation exists in list
  • Excel Data validation with conditional list
  • Excel Data validation date in next 30 days
  • Excel Data validation whole percentage only
  • Excel Data validation specific characters only

Flash Fill in Excel

by

Use flash fill in Excel 2013 or later to automatically extract or combine data.

Join

1. For example, use flash fill to join the last names in column A and the first names in column B to create email addresses.

2. First, tell Excel what you want to do by entering a correct email address in cell C1.

Worked Example:   How to Copy, Paste and Retain Exact Copied Formula in another Cell in Excel

3. On the Data tab, in the Data Tools group, click Flash Fill.

Result:

Note: again, Excel does not insert formulas, if you change the text strings in column A or column B, Excel will not update the email addresses in column C.

Worked Example:   How to return TRUE when all cells in range are blank in Excel

Extract

1. For example, use flash fill to extract the numbers in column A below.

2. First, tell Excel what you want to do by entering the value 4645 into cell B1.

Worked Example:   How to create dynamic named range with INDEX in Excel

3. On the Data tab, in the Data Tools group, click Flash Fill.

Result:

Note: Excel does not insert formulas, if you change the text strings in column A, Excel will not update the numbers in Column B.

Post navigation

Previous Post:

Remove Duplicates Example in Excel

Next Post:

How To Create Frequency Distribution in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to add a line break with a formula while joining text strings in Excel
  • Get first name from full name — Manipulating NAMES in Excel
  • REPLACE, REPLACEB functions: Description, Usage, Syntax, Examples and Explanation
  • REPT function: Description, Usage, Syntax, Examples and Explanation
  • Remove file extension from filename in Excel
  • Display Days in month in Excel
  • Convert Excel time to Unix time in Excel
  • Get day from date in Excel
  • DAYS360 function: Description, Usage, Syntax, Examples and Explanation
  • Get days, hours, and minutes between dates in Excel
  • FV function: Description, Usage, Syntax, Examples and Explanation
  • AMORLINC function: Description, Usage, Syntax, Examples and Explanation
  • IPMT function: Description, Usage, Syntax, Examples and Explanation
  • PPMT function: Description, Usage, Syntax, Examples and Explanation
  • Calculate cumulative loan interest in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles