how to remove delimeters on the right?

[orhanceliloglu]

Hello Everyone,

I have a column A with names as below.

My question : Is it possible to remove the extra semicolons at the end, while leaving the ones as separators? Please see the desired result as below example.

Any idea how i can code this in vba ?

Thanks
Orhan

Before Macro

A1- Brenda Miao; ; ;
A2- Xiaodan Fan; Helen Yang; Vivian Yuxiang Liu;
A3- Winnie Wang; Stella Li; ;

After Macro

A1- Brenda Miao
A2- Xiaodan Fan; Helen Yang; Vivian Yuxiang Liu
A3- Winnie Wang; Stella Li

[Andy Pope]

one way

Please Login or Register  to view this content.

[orhanceliloglu]

one way

Please Login or Register  to view this content.

Great. It worked perfectly. Thank you very much !