[resolved]perfect spaces in between words

VB Code:

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

Try this

Code:

---

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

---

Replace all double spaces by nothing

Pieter

awesome thanks