Split a string by delimiter and get last item - Google sheets

google-sheets

Formula

=INDEX(SPLIT(A2, " "), COLUMNS(SPLIT(A2, " ")))

• Here space is the delimiter
• COLUMNS counts the number of items in the resultant array
• INDEX gets the item from the array

Sources

• https://www.statology.org/google-sheets-split-get-last/