Excel: Help to remove ; trail from the middle of a string

Hi, I only find how to remove comma trails from the end of a string in VBA. But i have them in the middle like this. one;two;;;;three;four; how do i clean it in VBA so it looks like this one;two;three;four;

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of April 09, 2015.

For more resources for Microsoft Excel