🔐 Karlo Luiten

Excel return text right of last occurrence of string

—

by

karlo
in

=TRIM(RIGHT(SUBSTITUTE(A1;” “;REPT(” “;LEN(A1)));LEN(A1)))