Copy multiple numbers from a single cell to individual cells

[Styler001]

I am using Excel 2010.

At work, we've got a program that outputs the results of a search into an Excel file, in column 1 below.

17,43,61,63	17	43	61	63
23,29,53,57,77,79	23	29	53	57	77	79
17,29,63,69,71,75,79	17	29	63	69	71	75	79
11,43	11	43
57	57

I need to get that list of numbers listed out to the right, with one number per cell. The list in column one could possibly contain from 1 to 20 numbers, and the last number is always without the comma after it.

I know absolutely nothing about how to go about getting this done. I know it's probably not possible with a "normal" macro. If one of you gurus here could help out, I would be immensely greatful.

Thank you in advance.

Steve

[sktneer]

Why don't you use Text to Columns. Use comma as delimiter.

[Styler001]

OH MY GOD!!!!

That was too easy. I am so sorry for wasting space on this forum with a problem as easy to fix as this. I'm so embarrassed.

Thank you, sktneer.

[sktneer]

Cool......sometimes it happens with everyone.
If that takes care of your question, please mark your thread as solved. Thread Tools --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

[Styler001]

Thanks for pointing out the "add rep". I didn't see that. And I did figure out how to use it.

Thanks so much for helping out this newb.

[sktneer]

You're always welcome. Thanks for the Rep.