Substituting in a Calculation Field

[DougDinneen]

I'm trying to substitute out some extra characters from a last name. Is there a way to use the Substitute() function to replace more than one character at a time? I'm trying to take out ', -, and spaces from last names, but when I do three substitutes, it gives me the name three times. Help!

-Doug Dinneen

[DougDinneen]

Never mind, had a brain fart and figured it out. I just used nested substitutes. Duh me.

-Doug Dinneen