Microsoft Techies: Excel sub string formula based on last comma

Showing posts with label Excel sub string formula based on last comma. Show all posts

Thursday, 28 January 2016

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