Concantenate Social Security numbers currently parsed out

G

Guest

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
 
P

Pete_UK

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
 
G

Guest

Thanks, Pete! That worked perfectly!

Pete_UK said:
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
Click to expand...
 

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

Social Security Formatting 1
Concantenate Text with numbers with fixed form 2
social security numbers in Excel 3
Unformating social security numbers 4
Social Security numbers 5
social security sorting 4
Leading Zeros; How to Keep ? 2
Using Parsed String Results in VLOOKUP 2

Top