Convert Social Security text to number?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to convert a text social security number (###-##-####) to a
numerical format (#########) so that it can search using vlookup functions.
Any help is greatly appreciated.

-Joe
 
it depends on whether it is numeric formated with the dashes or Text with the
dashes embedded.
goto <format><cells><number> and select general
if the dashes are still there it is text.
select the cells and use find replace (Find the dash replace with nothing)
the cells will still be text, so enter 1 in a cell copy it select the SSN
cells and paste special Multiply
 
One way would be as follows:-

A1 contains SS number so in B1 enter the following
=(LEFT(A1,3)&MID(A1,5,2)&RIGHT(A1,4))*1
 
Back
Top