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 quickly select every other cell in Excel using three ingenious tricks (using Go To special, Filter, and a VBA macro code)| 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
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 apostrophes in Excel with three fool-proof methods (using Text to columns, a multiplication trick, and simple VBA code)| 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