Now that you know the basics about Excel custom functions, letâ s create one. In the example below, I will create an Excel function to calculate all odd numbers from a specific cell range.

Use keyboard shortcuts to remove formatting in Excel. Clear all formatting using the Format Painter tool. Run a VBA code to remove formatting. Remove formatting from a picture.

Want to delete or truncate numbers to the left in Excel? Learning how to remove numbers in Excel from the left is a neat trick to automate subtracting unwanted digits.