Hi,
I have the below data in a cell separated out by commas.
914761,991049,9917052,990306,9900307,9920268,990293,14962
I want to break these numbers out to separate columns by the ","so i'd create 8 columns in the example above. How can I do this with a formula, or should I just do a text to columns?
Thank
I have the below data in a cell separated out by commas.
914761,991049,9917052,990306,9900307,9920268,990293,14962
I want to break these numbers out to separate columns by the ","so i'd create 8 columns in the example above. How can I do this with a formula, or should I just do a text to columns?
Thank