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

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

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

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