Remove leading characters.

[ManVee]

I have a cell with this data and the number of commas at the end differ. How do I re move these commas?

Form this 1st Port Natal Sea Scouts Base, Durban, , ,, ,

To this 1st Port Natal Sea Scouts Base, Durban

Thank you very much for your help.

[AlKey]

Try this
Enter formula in cell B1

Please Login or Register  to view this content.

v	A	B
1	1st Port Natal Sea Scouts Base, Durban, , ,, ,	1st Port Natal Sea Scouts Base, Durban

[ManVee]

Thank you so much. You are Awesome! it worked. If it is not a problem, please explain how this formula works?

[Bo_Ry]

Or

=LEFT(A1,MATCH(2,INDEX(1/(CODE(MID(A1,ROW(1:99),1))>96),)))

MID(A1,ROW(1:99),1) to split each character.

CODE(MID()) to find character code Code("a") = 96 Code("z") = 122 code(",") = 44
CODE()>96 a,…,z will be true "," will be fault

1/code() true will get 1 false will get #DIV/0!

Match use to find MATCH(2,index(1/code())) if for find last position of character.

[Bosco]

Or……………

=LEFT(A1,MATCH(1,INDEX(0/(MID(A1,ROW(1:99),1)>"9"),)))

Regards
Bosco