Extract Text

7 lessons in order

Learn how to extract text between two characters in Excel using TEXTBEFORE, MID, Flash Fill, and other powerful functions easily.

Learn how to extract text after a character in Excel using MID, FIND, LEN, RIGHT, SEARCH functions, or the Text to Columns feature.

Learn how to extract text before a character in Excel using TEXTBEFORE, LEFT & FIND, Flash Fill, Text to Columns, and VBA.

Learn how to extract email addresses from text in Excel using Flash Fill, formulas, Power Query, and VBA for quick data cleanup.

Learn how to extract specific text in Excel using LEFT, RIGHT, MID, TEXTBEFORE/AFTER, FIND, SEARCH, SUBSTITUTE, and delimiter-based formulas.

Learn how to extract text after the last character in Excel using RIGHT, SEARCH, SUBSTITUTE, TEXTAFTER, REPLACE, XLOOKUP, and custom VBA.

Learn how to extract text after the Nth character in Excel using RIGHT, FIND, MID, TEXTAFTER, TEXTSPLIT, INDEX, TRIM, and SUBSTITUTE.