Skip to main content

Index - script and chart function

Index() searches a string to find the starting position of the nth occurrence of a provided substring. An optional third argument provides the value of n, which is 1 if omitted. A negative value searches from the end of the string. The positions in the string are numbered from 1 and up.

Syntax:  

Index(text, substring[, count])

Return data type: integer

Arguments:  

Arguments
Argument Description
text The original string.
substring A string of characters to search for in text.
count Defines which occurrence of substring to search for. For example, a value of 2 searches for the second occurrence.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!