Quote Originally Posted by lilit2222 View Post
Does this also take into account if there are two or more spaces?
Not sure if you are asking me or jindon that question. Mine does and, while I haven't done anything with Regular Expressions in over 30 years, jindon's looks like it should. In any event, why not just try each of our routines and see. Either do that on a copy of your workbook or, if you do it on your live workbook, simply close it without saving if the code does not work.