Thanks. I'll be using Applicaiton.WorksheetFunction.Substitute(variable, " "_")

"Frank Kabel" wrote:

Hi
=SUBSTITUTE(A1," ","_")

--
Regards
Frank Kabel
Frankfurt, Germany


Sworkhard wrote:
Is there and easy way to find and replace the " " in the example
above to "_"? . If not I will have to loop throught each character
in the string using the left and right functions and then recompile
the string.