View Single Post
  #1   Report Post  
Pii via OfficeKB.com
 
Posts: n/a
Default Strippinng characters out of excel

I have a bunch of social security numbers for employees in the following
format. We are exporting this report to the tax office and they do not
accept hyphens in the ss numbers. We have over 1000 numbers and I don't
want to do it by hand. Thanks in advance

123-456-7890

Need it to look like
1234567890