Learn four ways for formatting numbers in millions in Excel, including custom number formatting, using the TEXT function, the ROUNDUP function, and changing display units on a chart.| Spreadsheet Planet
Learn how to count cells with text in Excel using simple formulas and wildcard characters. This tutorial covers various scenarios, including excluding blank cells and apostrophes.| Spreadsheet Planet
Learn how to add leading zeros in Excel using various methods such as apostrophe, custom number formatting, and functions. Find out how to retain leading zeros and apply these methods to multiple cells.| Spreadsheet Planet
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
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 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 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
We often need to work with names in Excel. A lot of times we might need to work with a certain part of names in a list.| 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
Learn how to remove parentheses (brackets) in Excel using the Find and Replace feature, the SUBSTITUTE function, and VBA.| 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 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 extract numbers from mixed text in Excel. Whether the number is at the beginning, end, or middle of the text, these formulas and functions will help you clean your data.| 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 quickly remove extra spaces before text in Excel using functions, formulas, VBA code, and more. Get rid of leading spaces hassle-free!| Spreadsheet Planet
Learn how to easily remove the last digit from your data in Excel using built-in functionalities, LEFT/LEN functions, and the Flash Fill feature.| Spreadsheet Planet
Learn how to generate random letters in Excel for sample text, testing formulas, or security keys and passwords. Use CHAR and RANDBETWEEN functions to create uppercase, lowercase, or mixed strings.| Spreadsheet Planet
Discover 10 amazing time-saving hacks using the Ctrl + E shortcut in Excel. Learn how to utilize Flash Fill for tasks like unconcatenating data and converting text to UPPERCASE.| Spreadsheet Planet
Learn how to change all caps to lowercase, except the first letter, in Excel (using the PROPER, LOWER, RIGHT, and LEFT functions)| 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
Learn three easy ways to change uppercase to lowercase in Excel. Use the LOWER function, PROPER function, or Flash Fill for quick and efficient text transformations.| 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 3 methods to remove text after a specific character in Excel, including Find and Replace, Formulas, and VBA. Also, remove text after the nth instance of a character.| Spreadsheet Planet
Learn how to remove specific characters from strings in Excel using functions, formulas, and features.| Spreadsheet Planet
There might be some cases where you may want to remove the last four characters from the dataset in Excel.| Spreadsheet Planet
Learn how to remove the first character from a data set in Excel using different methods such as Flash Fill, built-in functions, and Text to Columns| 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 easily convert text to sentence case in Excel using various methods, including Flash Fill and formulas.| Spreadsheet Planet
Learn how to concatenate strings in Excel with line breaks using the ampersand operator (&), CONCATENATE function, and TEXTJOIN function| Spreadsheet Planet