J
jer101
I have a column of numbers that are 21 digits long. For
each number the first 7 digits represent a department,
the next 5 digits represent a class and the last 9 digits
represent the account #. Is there a simple way to
separate the single column of numbers into 3 columns
with the appropriate headings?
An example of the type of numbers in the column is as follows:
100310310000513000000
105210010000521000000
101900020000521000000
105400010000521000000
105900020000723000000
104600010000522000000
101710010000524000000
102600020000521000000
10262212000052100000
each number the first 7 digits represent a department,
the next 5 digits represent a class and the last 9 digits
represent the account #. Is there a simple way to
separate the single column of numbers into 3 columns
with the appropriate headings?
An example of the type of numbers in the column is as follows:
100310310000513000000
105210010000521000000
101900020000521000000
105400010000521000000
105900020000723000000
104600010000522000000
101710010000524000000
102600020000521000000
10262212000052100000