VBA for spaces

[ericlch16]

I have a variable string which can be

"test test"
"test asdasd"
"aa lol"

The space between the word can vary from 1 space to unlimited space.

What is the quick way in VBA for me to change the variable string so that there is only 1 space between the words. e.g it becomes

"test test"
"test asdasd"
"aa lol"

 

[RoryA]

You can use

Application.Trim("your phrase")