Skip to main content
Windward

LASTINDEXOF Function

autotag-wiki-logo.pngOverview

The LASTINDEXOF function returns the index of the last occurrence of one text string within another text string.

For example,

=LASTINDEXOF("This is great.", "is")

would return 5.  "is" can be found at both index 2 and 5, bit 5 is later in the string so 5 is returned.

Syntax

LASTINDEXOF(within_text,find_text)

  • within_​text - Required. The text containing the text you want to find.
  • find_text - Required. The text you want to find.
  • Was this article helpful?