Tuesday, 15 November 2016

Excel formula to Find text after last space in string

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),LEN(A1)))

No comments:

Post a Comment