Search code examples
google-sheetsgoogle-sheets-formula

How to find the Second Space from the right in Google Sheets?

I am looking for a way to find the second space from the right in Google Sheets and keep the text upto that second space. In Excel, this can be achieved by using the command

=TEXTAFTER(A1, " ", -2)

How can I do the same for Google Sheets?

Solution

  • You may try with:

    =regexextract(A2,"[^ ]+ [^ ]+$")

    enter image description here