Learn how to clear filters in Excel with simple keyboard shortcuts or using the ribbon option + learn how to identify if filters have been applied| 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 multiple ways to convert columns into rows in Excel, including using the transpose feature, paste special, keyboard shortcuts, and the TRANSPOSE function.| Spreadsheet Planet
Learn how to combine two columns in Excel with space or comma using six simple methods. From using the ampersand operator to the Flash Fill feature, this tutorial covers it all.| Spreadsheet Planet
At times, you might need to transpose or change your Excel data from several rows into a single column, as shown below:| Spreadsheet Planet
When working with spreadsheets that contain names, keeping first and last names in separate columns is often convenient.| Spreadsheet Planet
Learn how to remove apostrophes in Excel with three fool-proof methods (using Text to columns, a multiplication trick, and simple VBA code)| Spreadsheet Planet
Learn how to flip data in Excel - columns, rows, and tables using different methods such as helper columns, formulas, and VBA.| Spreadsheet Planet
Learn how to separate address in Excel using Text-to-columns, Flash Fill, and LEFT, RIGHT, and MID functions. Split addresses into street, city, state, and zip code columns.| Spreadsheet Planet
Learn how to reverse a text string in Excel using formulas and VBA scripts. This tutorial provides step-by-step instructions for both methods.| Spreadsheet Planet
Learn 5 methods to separate names in Excel, including Text-to-Columns, Flash Fill, Find and Replace, Formula, and Power Query.| Spreadsheet Planet
Learn how to easily count how many times a word appears in Excel using simple formulas and VBA.| 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