• Home
 · 
• String Manipulation
 · 
• This function makes sure you have only one space in between words, instead of multiple spaces in a

This function makes sure you have only one space in between words, instead of multiple spaces in a

This function makes sure you have only one space in between words, instead of multiple spaces in a string. I also have a ton of organized free

Rate This function makes sure you have only one space in between words, instead of multiple spaces in a

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

    Dim strA As String
    Dim i As Integer
    
    strA = str
    
    For i = 20 To 2 Step -1
    strA = Replace(strA, Space(i), Space(1))
    Next i
    
    KillSpaces = strA

End Function