I have text something like this, where there can be variable multiple spaces between words.
I'd like the PARSE functions to treat multiple spaces as a single space, but that's not how they seem to work.
I can do this, where 20 is the max number of spaces that will happen.
That solution seems inelegant, not to mention that I have to guess the max number of spaces. Is there a simpler way anyone uses?
one two three
I can do this, where 20 is the max number of spaces that will happen.
Code:
For i = 20 To 2 Step -1 Replace Space$(i) With " " In temp$ Next i
Comment