Concantenate Social Security numbers currently parsed out

M

MikkiFes

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
 
M

MikkiFes

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

VLOOKUP Returning a #N/A 2
Auto concantenate 1
How can the font and size of (all) citation numbers be altered? 1
Working with social security numbers 4
social security numbers in Excel 3
Social Security Formatting 1
Conditional Formatting from a group 6
Unformating social security numbers 4

Top