Let's say you have a variable "strNames" with the following value: "Ed,
Peter, Tom, Ron"

Try something like this:

Replace(strNames, ", ", " ")

Would yield strNames = "Ed Peter Tom Ron"

Regards

Kevin

"Simon" wrote in message
...
I would like a code to stop having and "," in the test

I will run the code on exit

what code do i need to use to do find and replace "," with nothing

Thanks