Function: CLEAN

Function: CLEAN

The Excel CLEAN function is a Text formula that removes “non-printable” characters from a text string. The function is especially useful for eliminating unsupported characters from a text that was imported from an external source. In this guide, we’re...
How to customize AutoCorrect

How to customize AutoCorrect

The AutoCorrect is an essential feature which is designed to correct typos automatically. This feature is also helpful for changing abbreviations to full versions, adding symbols, or correcting grammar errors, but it can also sometimes do things in a way that...
How to insert a cent symbol (¢) in Excel

How to insert a cent symbol (¢) in Excel

Unlike the dollar sign ($), the cent symbol doesn’t have a place in our keyboards. In this article, we’re going to show you how to insert a this symbol in Excel, and walk you through 5 different methods to do this.Copy & PasteCopy & Paste the...
How to insert a delta symbol in Excel (Δ)

How to insert a delta symbol in Excel (Δ)

Delta, which is the 4th letter of the Greek alphabet, is widely used in mathematics and science. Unfortunately, most keyboards don’t have this key and you would have to use different methods to get it in your Excel spreadsheets. In this article, we’re...