Remove dash from soc sce #

  • Thread starter Thread starter AccessVBBef
  • Start date Start date
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
 
Assuming Access 2000 or higher, use the Replace function:

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