How to remove the "-" from SSN's

  • Thread starter Thread starter Phyllis
  • Start date Start date
P

Phyllis

Hello,

I have two list on which I'm trying to compare the SSN's.
However, one list has the SSN entered as XXX-XX-XXX and
the other has XXXXXXXXX and then it's formatted with
special format for SSN. So when I compare the lists it's
not finding any matches. How can I remove the "-" from
the first list? Any help is very much appreciated.
 
Select the column, press Ctrl+H, and fill in "-" (no
quotes) for "Find what:". Press "Replace All".

HTH
Jason
Atlanta, GA
 
From the Edit menu, choose Replace

Put the dash in the Find and don't put anything in the
Replace field.

HTH
Erin
 
if they don't match up afterward check =ISNUMBER(A1)
or =ISTEXT(a1) either one will due. I would suggest that
use text for id data, but the main thing is that they must be the same.
 
Option A: Format the data without hyphen as SSN data
1. FORMAT
2. CELL
3. SPECIAL
4. SSN

Option B. Replace the hyphen with nothing (not even a
blank space).

1. Select the column with hyphenated data ( to avoid
deleting hyphens in other area.
2. Select EDIT
3. REPLACE
4. In find what: -
5. In Replace with: leave blank. You may need to open the
option box for the replace to work.

If the result is expressed in power of 10, check the
format.

Email me your phone number if you need help. I will call
you back.
Patrick Duong
 
thank you to all who answered my question. All of your
suggestions worked. thanks again.
 
Back
Top