Formulas & Functions
TEXTAFTER in Excel: get the text after a character
TEXTAFTER returns everything after a delimiter — the domain after @, the last name after a space, the text after the last slash. With the older RIGHT/FIND version.
Learn Excel the easy way.
Short, plain-English tutorials on formulas, shortcuts, charts and everyday Excel tasks. No jargon. One idea per post.
Start here Get Daily One LessonLatest tutorials
Formulas & Functions
TEXTBEFORE in Excel: get the text before a character
TEXTBEFORE returns everything before a delimiter — a space, @, comma or word. Pick the 2nd or last occurrence, handle missing delimiters, and the older LEFT/FIND version.
Formulas & Functions
ISBLANK in Excel: check if a cell is empty
ISBLANK returns TRUE for an empty cell. Use it inside IF, know why it says FALSE for cells that look empty, and the = test that often works better.
Data Cleaning
How to Find Blank Cells in Excel (select, count, fill)
Select every blank cell at once with Go To Special, count them with COUNTBLANK, highlight them, and fill them with 0 or the value above in one step.
Formulas & Functions
How to Count Words in Excel (formula for a cell or a range)
Excel has no word count button. Count words in a cell with LEN, TRIM and SUBSTITUTE, total a whole column, and count one specific word.
Formulas & Functions
Count Occurrences in Excel (a value, a word, or a character)
Count how many times a value appears in a range, how many cells contain a word, how often a character appears in a cell, and a count for every item at once.
Formulas & Functions
Excel IF Greater Than: formulas with >, >= and between
Write IF formulas that test whether a value is greater than, less than or between two numbers, compare to another cell or date, and return text or a calculation.
Formulas & Functions
SUMIF Greater Than in Excel (numbers, cells and dates)
Add up values greater than a number, a cell or a date with SUMIF, sum one column based on another, and sum between two limits with SUMIFS.
Formulas & Functions
COUNTIF Not Equal To in Excel (<>)
Count cells that are not equal to a word, number or cell with the <> operator, count non-blank cells, and exclude several values at once.
Showing 28–36 of 294 tutorials · Page 4 of 33
