TAX ID

[nnadimi19]

Good Morning;

I have a column with 10,000 rows. In this column I have Tax Id (99-99999999) and social security number (999-99-9999). Is there any way I can break them up into two seperate columns?

Thanks

 

[RAM]

Good Morning,

Yes, with Data-Text to Columns, select Fixed width and go Next, Move the break line to desired postion and Next, select the data format and Finish.

HTH

 

[nnadimi19]

I tried the suggession. Tax Id is 10 characters and social security is 11 so what this did was move the last digit to the next column. What I really want to do is completely seperate the tax id and the social security number.

 

[RAM]

I tried it again and I have no problems. You might not have placed the line to signify the column break where it should have been. I don't know that the different columns must have the same number of characters.

Do an Undo and try again.

 

[shammy]

What exactly is seperating the two values? Is it a comma, space?

TaxID-SSN

99-9999999,999-99-9999
99-9999999 999-99-9999
99-9999999_999-99-999

 

[Peter_SSs]

nnadimi19

Can we confirm exactly how your data is shown in the column?
Is it
99-99999999999-99-9999 or
(99-99999999)(999-99-9999) or
99-99999999,999-99-9999 or
something else?

Edit: Whoops, shammy beat me to it.

 

[RAM]

Ooops....Sorry,my bad but that will do it. Then you use Delimited instead of Fixed with.

Thanks guys for helping. Have a great w/e.