LEN(), LEFT(), RIGHT(), FIND() and SEARCH()

LEN()

The LEN function investigates a cell and returns the number of characters in the text or string.

LEFT()

The LEFT() function returns a specified number of characters starting with the left most character of a cell.
For example LEFT(B2,5) returns five characters in cell B2 starting from the left most character.

RIGHT()

Unsurprisingly the RIGHT() function does exactly the same but starting at the right most character.

FIND()

The FIND() function returns the starting position of one text string within another text string. The example below shows that the text “Launchpad” starts at the 7th character in the string within cell F2.

Excel Find function

SEARCH()

The search function is almost identical to the FIND() function however the main difference is that the SEARCH() function is case sensitive whereas the FIND() function is not.

The example for the SEARCH() function is therefore very similar to the one for FIND().

Excel Search function