Need A Macro that Will Remove Comas and place Data in multiple Cells

[foible81]

I have a sheet of data with large amounts of information contained in just one cell. All of the numbers are separated by comas though, and I hoped to see if anyone could help me organize the data. I'm relativly new to Macros, so I was drawing a blank on what I should do.

thanks.

 

[VoG]

Try selecting the data, Data > Text to Columns, specify Delimited with comma as the delimiter. Click Finish.