Data Cleaning
Convert Text to Number in Excel: 4 ways, fastest first
Convert text to numbers in Excel: the green-triangle button, Paste Special multiply, VALUE, and Text to Columns — and how to tell text from numbers.
Category: Data Cleaning
Data Cleaning
Remove Spaces in Excel: leading, trailing, all, or double
Remove spaces in Excel: TRIM for extra spaces, SUBSTITUTE for every space, Find and Replace for a one-off, and the invisible space that survives all three.
Data Cleaning
TRIM in Excel: remove extra spaces that break lookups
TRIM in Excel removes leading, trailing and double spaces — the fix for VLOOKUPs that fail and duplicates that won't merge. Plus the space TRIM cannot remove.
Data Cleaning
Text to Columns in Excel: split names, addresses and codes
Text to Columns in Excel step by step: split by comma, space or a fixed width, keep leading zeros, and undo when it goes wrong.
Data Cleaning
Delete Blank Rows in Excel: all of them at once
Delete every blank row in Excel in one go with Go To Special, the filter method for partly empty rows, and the mistake that deletes real data.
Data Cleaning
Split a Cell in Excel: one column into two
Split a cell in Excel: full names into first and last with Text to Columns, or the instant Flash Fill trick, plus TEXTSPLIT for newer Excel.
Data Cleaning
Find and Replace in Excel: fix a word everywhere at once
Find and replace in Excel with Ctrl+H: change a word across the sheet, replace in a selection only, and remove characters by replacing with nothing.
Data Cleaning
Remove Duplicates in Excel: 3 clicks, no formula
Remove duplicates in Excel with the built-in button in three clicks, and see the two ways it goes wrong.
8 tutorials · Page 1 of 1
