Excel Forum
Similar Content
List All Files from a Directory into Excel
: Get a list of all files from a directory into an Excel worksheet. This allows you to navig...
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Understanding Formulas and Functions in Excel
Tutorial: In this tutorial I will cover the basic concepts of Formulas and Functions in Excel. A for...



Excel Magic Trick 338: Extract Records By E-mail Extension


See how to use the REPLACE and FIND functions in a new column to extract e-mail extensions, and then use Filter or Advanced Filter to Extract records according to e-mail extension. See Advanced Filter with one criterion criteria.





Got a Question? Ask it Here in the Forum.