View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MikkiFes MikkiFes is offline
external usenet poster
 
Posts: 2
Default 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