How to find Last Position of a Character in a Text or String in Google Sheets

Опубликовано: 27 Июнь 2026
на канале: Apply IT
1,151
9

#GoogleSheets, #GoogleAppsScript, #FINDLAST, #AppsScript, #AppScript, #FindRight, #FindEnd, #ReverseSearch, #ReverseFind
This video practically demonstrates how to find the last occurrence of a character in a text or string in Google Sheets or Microsoft Excel or Spreadsheet. Google Sheets does not provide a function to reverse string or text. We use reverse() function created in our previous video and use to find a desired character from the right or end of the string. Reversing a string has many applications; We demonstrate how we can use the last occurrence of a character to split the full file name into folder name and file name.

Do watch our previous video on "How to Reverse Text in Google Sheets using Google Apps Script" at    • How to Reverse Text in Google Sheets using...  

This video also answers many related questions such as
How to find Last Position of a Character in a Text or String in Google Sheets
How to find Last Occurrence of a Character in a Text or String in Google Sheets
Using reverse() function of Google Apps Script
Google Sheets find last occurrence in string
Google Sheets find last occurrence in text
Google Sheets find from Right
Google Sheets find from End
Find Position of the Last Occurrence of a Character in Excel
Find Position of the Last Occurrence of a Character in Google Sheets
FIND LAST Formula in Excel
FIND LAST Formula in Google Sheets
FIND RIGHT Formula in Excel
FIND RIGHT Formula in Google Sheets
FIND END Formula in Excel
FIND END Formula in Google Sheets
REVERSE FIND Formula in Excel
REVERSE FIND Formula in Google Sheets
Excel formula Split text or string at specific character
Split file name and folder name using Google Sheets
Find the last occurrence of a character
Excel: Find the last occurrence of specific character
Google Sheets: Find the last occurrence of specific character
How to find last index of a character from a string or text in Google Sheets or Microsoft Excel
Find last occurrence of / slash in Google Sheets
Find last occurrence of / slash in Microsoft Excel
Find last index of / slash in Google Sheets
Find last index of / slash in Microsoft Excel
How to find the last index of a character in a string
Search a character from the end of a string or text
Search a character from right of a string or text