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