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 OFFSET function
  • Lookup entire row in Excel
  • Convert text string to valid reference in Excel using Indirect function
  • To count total rows in a range in Excel
  • Merge tables with VLOOKUP in Excel

Data Analysis Examples

  • Understanding Pivot Tables in Excel
  • Remove Duplicates Example in Excel
  • How to create Checklist in Excel
  • How to count table columns in Excel
  • Subtotal function in Excel

Data Validation Examples

  • Excel Data validation with conditional list
  • Excel Data validation don’t exceed total
  • Excel Data validation date in next 30 days
  • Excel Data validation must not contain
  • Excel Data validation allow weekday 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:   Check multiple cells are equal 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:   Understanding Cell Ranges, Auto fills, Copy/Paste, Insert Row, Column 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:   Cell References: Relative, Absolute and Mixed Referencing Examples

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 count line breaks in cell in Excel worksheet
  • Add line break based on OS in Excel
  • How to extract substring in Excel
  • How to compare two text strings in Excel
  • Extract most frequently occurring text in Excel
  • How to join date and text together in Excel
  • Assign points based on late time in Excel
  • Get day from date in Excel
  • DAYS function: Description, Usage, Syntax, Examples and Explanation
  • Roll back weekday to Friday base on a particular date in Excel
  • TBILLPRICE function: Description, Usage, Syntax, Examples and Explanation
  • SLN function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYSNC function: Description, Usage, Syntax, Examples and Explanation
  • Calculate original loan amount in Excel
  • IPMT function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles