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...
Function: LEN

Function: LEN

The Excel LEN function is a Text formula that returns the number of characters in a given string. In this guide, we’re going to show you how to use the Excel LEN function and also go over some tips and error handling methods. Supported versions All Excel versions...
Function: EXACT

Function: EXACT

Excel EXACT function compares two strings and returns TRUE for a perfect match, and FALSE if not. Note that this comparison is case-sensitive. In this guide, we’re going to show you how to use Excel EXACT function to compare strings and also go over some tips and...
How to wrap text in Excel

How to wrap text in Excel

By default, Excel will cut off the characters that don’t fit into a certain space. An alternative approach is wrapping the text to fully display it by increasing the cell height. In this guide, we’re going to show you how to wrap text in Excel. These methods...
Function: TEXT

Function: TEXT

Excel TEXT function helps apply a certain formatting to a numeric value. You can think this function as an alternative to number formatting. In this guide, we’re going to show you how to use the TEXT function and also go over some tips and error handling methods....
How to insert a degree symbol in Excel

How to insert a degree symbol in Excel

The degree symbol (°) typically indicates temperature measurement, the magnitude of angles in geometry, and diminished chords in music. However, standard keyboards don’t have a button for this useful symbol. In this article, we’re going to show you 4...
How to insert a check mark in Excel

How to insert a check mark in Excel

A check mark is the universal character for confirmed tasks and is widely used in managing lists. Seeing how commonly it’s used in organizing ourselves, you would think that there should be a keystroke for this! In this article, we listed 5 methods you can use...
Function: SEARCH

Function: SEARCH

Excel SEARCH function returns an integer that represents the position of a specified character or substring within a text. In this guide, we’re going to show you how to use the Excel SEARCH function and also go over some tips and error handling methods. Supported...
Function: FIND

Function: FIND

Excel FIND function returns an integer that represents the position of a specified character or substring, within a text. In this guide, we’re going to show you how to use Excel FIND function, and also go over some tips and error handling methods. Supported versions...