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 copy formatting in Excel using Format Painter, Paste Special, Fill Handle, and more. Easily apply formatting to single or multiple cells with these simple methods.| 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
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 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 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