Remove dash from soc sce #

A

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
 
D

Douglas J Steele

Assuming Access 2000 or higher, use the Replace function:

Replace(SSN, "-", "")
 
Top