This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
Choose Language Hide Translation Bar
dwaterson
dwaterson
Level III

I have a column of comma separated numbers. Is it possible to separate each number into its own column?

Sep 11, 2014 06:40 PM (10122 views)

I have a column of comma separated numbers. Is it possible to separate each number into its own column?

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Jeff_Perkinson
Community Manager Community Manager
Solution

Re: I have a column of comma separated numbers. Is it possible to separate each number into its own column?

Created: Sep 12, 2014 09:09 AM  |  Last Modified: Oct 28, 2016 09:13 AM (12360 views)  |  Posted in reply to message from dwaterson 09-11-2014

The Text to Columns, Version 2 add in will help you out here.

-Jeff

-Jeff

View solution in original post

0 Kudos
2 REPLIES 2
Jeff_Perkinson
Community Manager Jeff_Perkinson
Community Manager Community Manager
Solution

Re: I have a column of comma separated numbers. Is it possible to separate each number into its own column?

Created: Sep 12, 2014 09:09 AM  |  Last Modified: Oct 28, 2016 09:13 AM (12361 views)  |  Posted in reply to message from dwaterson 09-11-2014

The Text to Columns, Version 2 add in will help you out here.

-Jeff

-Jeff
0 Kudos
dwaterson
dwaterson
Level III

Re: I have a column of comma separated numbers. Is it possible to separate each number into its own column?

Sep 12, 2014 10:31 AM (9694 views)  |  Posted in reply to message from Jeff_Perkinson 09-12-2014

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