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
Bookmarks