Learn how to apply the Accounting Number Format in Excel using three different methods. Also understand the differences from the Currency format| 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 how to quickly fill all the blank cells with 0 in Excel using Find and Replace, Go to Special, and VBA code.| Spreadsheet Planet
Learn three simple ways to remove macros from an Excel workbook (save in XLSX format, using Macro Dialog Box, and Visual Basic Editor)| 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
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 remove leading zeros in Excel using different methods - custom number format, text format, and formulas,. Also, remove a fixed number of zeros with ease.| Spreadsheet Planet
Learn how to remove the dollar sign in Excel using different methods such as formatting, formulas, Find and Replace, and the VALUE function.| 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 the differences between SUMPRODUCT and SUMIFS functions in Excel. Find out when to use each for conditional sums and more| 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
Learn how to remove dotted lines in Excel worksheets. This guide covers removing page break lines, cell border lines, and gridlines in spreadsheets.| 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 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
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 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