Parsing off last character if comma

[Rose]

I've received a huge mailing list, and about a third of
the last names have commas after them. I need to parse off
that comma if it's there.
I know I need a IF statement, presumably testing if RIGHT
(a1)=",", and A1 if the test is false, but I don't know
how to get the true test to delete the comma.

 

[Michael J. Malinsky]

I think this is what you're looking for.

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

HTH