Can anyone tell me how to replace a " with a space in a string? I am doing an import of a text file and one of the fields has a value of Johnson "ABC" Company and I need it to be Johnson ABC Company. I am working in Access/2000 and I can not figure out a way to remove the character. I have tried using the Replace() function, but it has a problem replacing the " character.