Last character of a string removal in excel

In Excel, what would be the best way to use the =RIGHT(A1, 1) in a statement to remove ,

If you mean how can you remove the last character only if it's a comma then try this formula

=LEFT(A1,LEN(A1)-(RIGHT(A1)=","))