Learn how to add the Developer tab in Excel and access advanced features like VBA programming and macros. Follow our tutorial for step-by-step instructions.| 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
Learn five super easy methods to swap columns in Excel, including drag and drop, cut and paste, sorting, SORTBY function, and copy, paste, and delete.| Spreadsheet Planet
Learn everything about the Formula Bar in Excel - where to find it, how to show/hide, shortcuts, and how it makes working with large formulas easier!| 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 remove middle names from full names in Excel using Flash Fill, Find and Replace, Text to Columns, TEXTSPLIT Function, and more.| Spreadsheet Planet
Learn how to switch first and last names with a comma in Excel using various methods such as Flash Fill, formulas, and VBA macro.| Spreadsheet Planet
When working with spreadsheets that contain names, keeping first and last names in separate columns is often convenient.| Spreadsheet Planet
Learn 7 time-saving techniques for applying a formula at once to an entire column in Excel. From using the fill handle to dynamic array formulas| Spreadsheet Planet
Learn how to reverse concatenate (Opposite of Concatenate) in Excel with these 5 techniques, including using Flash Fill and Text to Columns.| Spreadsheet Planet
Learn how to extract text after the space character in Excel using formulas, VBA code, and Text to Columns (step-by-step instructions).| Spreadsheet Planet
By default, the cells in Excel have a specific row height and column width.| 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 split one column into multiple columns in Excel using the 'Text to Columns' feature (step-by-step instructions)| 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
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