Learn three easy ways to get unique values from a column in Excel: Remove Duplicates tool, Advanced Filter, and UNIQUE function.| 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
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 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 generate unique random numbers in Excel without duplicates using the RANDBETWEEN, RAND, RANK, LARGE, and MATCH functions.| Spreadsheet Planet
Learn how to generate random names in Excel using TEXTJOIN, XLOOKUP, and RANDBETWEEN functions.| 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
When you work with Microsoft Excel, you might hear about something called ASCII.| 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 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
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 easily convert text to sentence case in Excel using various methods, including Flash Fill and formulas.| 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