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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working with social security numbers 4
Social Security Number 3
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
remove dashs from social security numbers 4
Preformatting Excel Prior to Opening Spreadsheet 1
Unformating social security numbers 4
how to reformat numbers 4
social security numbers in Excel 3

Back
Top