Function: ISNONTEXT

Function: ISNONTEXT

The Excel ISNONTEXT function is an Information formula that returns TRUE if the input value is a not text value, and FALSE otherwise. You can test the result of a formula or value of a cell using this function. This formula can be especially useful in organizing data,...
Function: REPT

Function: REPT

REPT is a Text function that repeats a string a given number of times. It is useful for filling a cell or fixed length of strings, as well as creating simple histograms. In this guide, we’re going to show you how to use REPT function and also go over some tips and...
Function: CONCATENATE

Function: CONCATENATE

The CONCATENATE Excel function is a Text formula that joins multiple strings together. You can enter static strings and individual cell references. In this guide, we’re going to show you how to use the CONCATENATE Excel function and also throw in some tips and error...
Function: TEXTJOIN

Function: TEXTJOIN

The TEXTJOIN Excel function is a Text formula that joins strings together with a delimiter. You can enter static text strings, a range of cells, and individual cell references to join. In this guide, we’re going to show you how to use the Excel TEXTJOIN function and...
Function: SUBSTITUTE

Function: SUBSTITUTE

The Excel SUBSTITUTE function is a Text formula that substitutes a text string with another. In this guide, we’re going to show you how to use the Excel SUBSTITUTE function, and also go over some tips and error handling methods. Supported versionsAll Excel...
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 versionsAll Excel versionsExcel...
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...