Learn how to quickly fill blank cells with a dash (-) in Excel using Find and Replace, 'Go To Special' technique, and VBA code.| Spreadsheet Planet
Learn how to quickly fill all the blank cells with 0 in Excel using Find and Replace, Go to Special, and VBA code.| Spreadsheet Planet
In this tutorial, I will show you two ways to find merged cells in Excel (using Find and Replace and VBA). Once found, you can unmerge these or highlight these| Spreadsheet Planet
Learn how to remove formulas but keep the data in Excel using a simple shortcut, the paste special technique or a simple VBA code.| Spreadsheet Planet
Learn how to find the position of the last space in a text string in Excel using a formulas or a VBA custom function.| Spreadsheet Planet
Learn how to use multiple IF statements in Excel with nested IFs, AND, and OR functions. Includes examples and alternatives to simplify complex formulas.| Spreadsheet Planet
Learn how to compare two columns in Excel using VLOOKUP. Find matches and differences in data, and highlight rows with matching or different values.| Spreadsheet Planet
Learn 4 easy ways to add text to the beginning or end of all cells in Excel using ampersand, CONCATENATE, Flash Fill, and VBA.| Spreadsheet Planet