Excel 15 digit issue, tried converting to text, text to column feature negates fix
I have the following numbers that exceed 15 characters that needs to be split into its own columns.
Down the road, there would be thousands of such rows of data with the first couple set of unique numbers.
890432453253208820,5004500558,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11 00:00:00.000,2007-02-10 23:59:59.000,ttt,
890432253253208820,5004600558,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11 00:00:00.000,2007-02-10 23:59:59.000,ttt,
890432453253208822,5004500758,05CC,1,0,0,0,0,0,0, 0000,5.0000,2007-01-11 00:00:00.000,2007-02-10 23:59:59.000,ttt,
Obviously one method would be to use the replace command, but I can not due to the uncertainty of the pattern of the first set of number.
I have tried formating them as text after pasting it into excel, it does the trick, but I need each set of numbers that are separated by commas into its own column, but once I do text to column, the first set of numbers which exceed 15 digits no longer show the full digits, only the first 15 digits.
Any help would be greatly appreciated.