INDEXOF - Returning the Character at a Specified Position in Text

• The value of index starts from 0.

• The INDEXOF function returns text-type data.

• The function supports two parameters, between which the first is of any type and the second is a number.

For example, if you want to filter out the Store Code field that end with 3, the INDEXOF function can be used.

Choose Filter > Add Formula, and enter INDEX(Store Code,6)="3", as shown in the following figure.

Note:

The INDEXOF function returns text-type data, so the value 3 in the filter formula needs to be enclosed in double quotes as the text type.

More examples: