Find and remove all text to the left of last comma (including comma) in a cell

Try this

Formula:

=TRIM(MID(SUBSTITUTE(A2,",","|",LEN(A2)-LEN(SUBSTITUTE(A2,",",""))),FIND("|",SUBSTITUTE(A2,",","|",LEN(A2)-LEN(SUBSTITUTE(A2,",",""))))+1,255))

Or to remove the text after and including, the last comma

Formula:

=LEFT(SUBSTITUTE(A2,",","|",LEN(A2)-LEN(SUBSTITUTE(A2,",",""))),FIND("|",SUBSTITUTE(A2,",","|",LEN(A2)-LEN(SUBSTITUTE(A2,",",""))))-1)