[resolved]perfect spaces in between words

[Whatupdoc]

HEY             WHAT   UP DUDE

how would i make it so that the spacing would be perfect. instead of having more than 1 space, i just want one space in between each word. i tried using the trim() function, but it only removes space from the beginning and end of the word

[[Pieter]]

Try this

Debug.Print Replace("HEY             WHAT   UP DUDE","  ","")

Replace all double spaces by nothing

Pieter

[Whatupdoc]

awesome thanks