Learn how to quickly select every other cell in Excel using three ingenious tricks (using Go To special, Filter, and a VBA macro 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 quickly unmerge all cells in Excel using the Merge and Center button, Find and Replace, VBA script, and how to copy original values to unmerged cells.| Spreadsheet Planet
Learn 4 different methods to enter sequential numbers in Excel, including using the Fill Handle, ROW function, SEQUENCE function, and converting the dataset into a table.| 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
There are occasions when we need to display different parts of a text string on different lines within the same Excel cell.| 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 remove commas in Excel, whether from numbers or text strings. Use Find and Replace, formulas, or the Text to Columns wizard.| 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 concatenate strings in Excel with line breaks using the ampersand operator (&), CONCATENATE function, and TEXTJOIN function| Spreadsheet Planet