Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden REPLACE Multiple Spaces with One RE: REPLACE Multiple Spaces with One

  • November 16, 2009 at 5:09 am

    #1079605

    Matt Whitfield (11/16/2009)

    Indeed

    I also realised why it can't work in a 'loop till it's finished' kind of way - because if you did REPLACE(expression, ' ', ' ') then it would never terminate...

    M

    ?

    but loop until no more double spaces is ok as in function fn_CleanUp?

    C# Gnu
    ____________________________________________________


    Excel Database Tasks : efficient business data processing
    Version 3.3 released February 2015