Replace

do multiple replaces work like:

Replace(str, ",", "", ".", "")

which should remove all instances of , and . from str

would it work?

no you have to do each one seperately

from msdn help...

Syntax

Replace(expression, find, replacewith[, start[, count[, compare]]])

how about:

Replace(Replace(str, ".", ""), ",", "")

That should work, but it's better practice to use the constant vbNullString instead of the "".

Quote:

---

Originally Posted by Comintern

That should work, but it's better practice to use the constant vbNullString instead of the "".

---

Ok. Thanks