| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Concantenate Social Security numbers currently parsed out
I have about 10000 social security numbers currently parsed out in the
following manner: Column 1 000 Column 2 00 Column 3 0000 I have tried to use CONCANTENATE to move them back over into one column, but the resulting number ignores all leading zeros currently in place. I need to have them set up into one column to use VLOOKUP. Can anyone help? Thanks! ~Mikki |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concantenate Social Security numbers currently parsed out
Assuming they are in columns A B and C, try this:
=TEXT(A1,"000")&TEXT(B1,"00")&TEXT(C1,"0000") then copy this down to row 10000 (or thereabouts). Hope this helps. Pete MikkiFes wrote: I have about 10000 social security numbers currently parsed out in the following manner: Column 1 000 Column 2 00 Column 3 0000 I have tried to use CONCANTENATE to move them back over into one column, but the resulting number ignores all leading zeros currently in place. I need to have them set up into one column to use VLOOKUP. Can anyone help? Thanks! ~Mikki |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concantenate Social Security numbers currently parsed out
Thanks, Pete! That worked perfectly!
"Pete_UK" wrote: Assuming they are in columns A B and C, try this: =TEXT(A1,"000")&TEXT(B1,"00")&TEXT(C1,"0000") then copy this down to row 10000 (or thereabouts). Hope this helps. Pete MikkiFes wrote: I have about 10000 social security numbers currently parsed out in the following manner: Column 1 000 Column 2 00 Column 3 0000 I have tried to use CONCANTENATE to move them back over into one column, but the resulting number ignores all leading zeros currently in place. I need to have them set up into one column to use VLOOKUP. Can anyone help? Thanks! ~Mikki |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Concantenate Social Security numbers currently parsed out
Glad to help - thanks for feeding back.
Pete MikkiFes wrote: Thanks, Pete! That worked perfectly! "Pete_UK" wrote: Assuming they are in columns A B and C, try this: =TEXT(A1,"000")&TEXT(B1,"00")&TEXT(C1,"0000") then copy this down to row 10000 (or thereabouts). Hope this helps. Pete MikkiFes wrote: I have about 10000 social security numbers currently parsed out in the following manner: Column 1 000 Column 2 00 Column 3 0000 I have tried to use CONCANTENATE to move them back over into one column, but the resulting number ignores all leading zeros currently in place. I need to have them set up into one column to use VLOOKUP. Can anyone help? Thanks! ~Mikki |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Dashes from Social Security Numbers | Excel Worksheet Functions | |||
| How do I format a social security number to have no dashes? | Excel Discussion (Misc queries) | |||
| How can I compare 2 sets of Social Security #'s and Identify dupes | Excel Discussion (Misc queries) | |||
| (social security number) 000-00-0000 to 000000000 | Excel Discussion (Misc queries) | |||
| social security sorting | Excel Worksheet Functions | |||
Linear Mode
