Excel First

Excel Solutions

LEN function: Basic and Advanced Examples

Site White Background

LEN function type: Text

Description: Returns the number of characters in a text string
LEN is a basic function widely used, many formulas built for text processing will need this function.

Take a look at the advanced applications examples:

Applications:

Read More

SUBSTITUTE function: Basic and Advanced Examples

SUBSTITUTE function type: Text

Description: Substitutes the old text with new text in a text string

Beyond its basic use, which is fairly simple, the SUBSTITUTE function can be very useful combined with other functions, to get your desired results.
Take a look at the advanced applications examples:

Applications:

Read More