Parsing off last character if comma

  • Thread starter Thread starter Rose
  • Start date Start date
R

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.
 
I think this is what you're looking for.

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

HTH
 
Back
Top