Application.Trim(string) to remove extra spaces


Gord Dibben MS Excel MVP

On Wed, 4 Feb 2009 11:41:59 -0800, John
wrote:

What's a quick way to remove multiple spaces between words in a string?

I tried ProjectName = Replace(ProjectName, " ", " "), but this sometimes
leaves multiple spaces between words in ProjectName.

I appreciate your help, -John