How to add values instead of spaces???

Hi,

Two ways

With a helper column enter - change bold if you don't need it starting www

="www."&SUBSTITUTE(A1," ","_")

then drag down and paste special values

or press Ctrl + H

in the find box press the space bar once to insert a space and in the replace box enter "_"

HTH

VBA Noob