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
When working with spreadsheets that contain names, keeping first and last names in separate columns is often convenient.| 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
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 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 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