Delete a comma on the right side of the cell

[martinez_pedro]

Hi Does anybody has a macro capable of remove the comma on the right side of the cell
Some names comes with a comma after the name and some they come normal


Before

Desire result:

Thank you for your help

[amotto11]

You could just use this formula here in cells B2 and drag down so you don't need a macro. Does this work?

=IF(RIGHT(A1,1)=",",REPLACE(A1,LEN(A1),1,""),A1)

If you needed a macro, all you would need to do is record yourself putting this formula in and place it in any existing code that you may have.

[K m]

=if(right(a1,1)=",",left(a1,len(a1)-1),a1)

[martinez_pedro]

Thank you those formulas worked for me

[Cutter]

@ martinez_pedro

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.