Data Cleaning
How to Separate First and Last Name in Excel (4 ways)
Split 'Asha Rao' into first and last name columns: Text to Columns, Flash Fill, LEFT/SEARCH formulas, or TEXTBEFORE/TEXTAFTER. Handling middle names and 'Rao, Asha'.
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
Data Cleaning
How to Change Case in Excel: UPPER, lower and Proper Case
Excel has no Change Case button like Word. Use UPPER, LOWER and PROPER, or Flash Fill, then paste the results as values. Plus sentence case and fixing names like McDonald.
Data Cleaning
How to Remove the Last Character in Excel (or the last few)
Cut the last character off a cell — a trailing comma, a unit letter, a check digit — with LEFT and LEN. Remove the last N characters, only when it's a certain character, and Flash Fill.
Data Cleaning
How to Remove the First Character in Excel (or the first few)
Strip the first character from a cell — a leading apostrophe, a letter prefix, a zero — with RIGHT and LEN, REPLACE, or Flash Fill. Removing the first N characters too.
Data Cleaning
How to Combine First and Last Name in Excel (4 ways)
Join a first name and last name into one cell with a space: the & formula, CONCAT, TEXTJOIN that skips blanks, and Flash Fill with no formula at all.
Formulas & Functions
IF Not Blank in Excel: do something only when a cell has a value
Run a calculation only when a cell is filled, and leave the result empty otherwise. The <>"" test, ISBLANK, checking two cells, and why 'blank' cells sometimes aren't.
Formulas & Functions
Excel PMT Function: monthly loan or EMI payment
PMT calculates the fixed monthly payment on a loan: home loan EMI, car loan, personal loan. Converting annual rate and years to months, total interest, and why the answer is negative.
Formulas & Functions
Excel HYPERLINK Function: clickable links from a formula
HYPERLINK builds a clickable link: a website from an ID, an email with subject, a jump to another sheet, or a file on your drive. Plus the no-formula way with Ctrl+K.
Formulas & Functions
Excel XMATCH: the modern MATCH (exact by default, searches backwards)
XMATCH returns the position of a value like MATCH, but defaults to exact match, can search from the last row up, and handles wildcards. Examples and when to use it.
Showing 100–108 of 294 tutorials · Page 12 of 33
