Remove dash from soc sce #

[AccessVBBef]

I would to remove dashes from 111-22-5555.
I am importing text file and some of the numbers have dashes and some
don't

Thanks

 

[Douglas J Steele]

Assuming Access 2000 or higher, use the Replace function:

Replace(SSN, "-", "")