You sometimes need to represent text data as bullet points in Excel. For example, you might need to display bulletin boards, to-do lists, etc.| 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 three easy ways to fill blank cells with the value above in Excel (using 'Go To Special' with a formula, 'Find and Replace' with formula, or VBA)| Spreadsheet Planet
Filling colors in cells in Excel could be quite useful.| Spreadsheet Planet
Learn how to remove commas in Excel, whether from numbers or text strings. Use Find and Replace, formulas, or the Text to Columns wizard.| Spreadsheet Planet
Learn how to delete filtered rows in Excel using filters and VBA. Also, find out how to delete hidden rows without VBA.| 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