I have a column of comma separated numbers. Is it possible to separate each number into its own column?<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />I have a column of comma separated numbers. Is it possible to separate each number into its own column?
Re: I have a column of comma separated numbers. Is it possible to separate each number into its own column?Hi Jeff,
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!
Dianne
Re: I have a column of comma separated numbers. Is it possible to separate each number into its own column?The Text to Columns, Version 2 add in will help you out here.
-Jeff