Learn how to easily remove negative signs in Excel with some practical methods (such as Flash Fill, formulas, and Find and Replace)| 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 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 count negative numbers in Excel using COUNTIF formulas and a simple VBA macro code.| 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 how to display negative numbers in parentheses or brackets in Excel using custom number formatting methods for better readability.| 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 commas in Excel, whether from numbers or text strings. Use Find and Replace, formulas, or the Text to Columns wizard.| 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