I have a column of comma separated numbers. Is it possible to separate each number into its own column?
Solved! Go to Solution.
Thank you for the Text to Columns add-in. It loaded well and ran well. It did take some time to go through the >5 million rows of data and >40 comma separated values, around 5 mins. So much better than creating a programming each column myself as that would take much longer!