Data in cells separated by commas

[upcea]

I have about 3,000 cells with data separated by commas that I need to extract. For example in a single cell I have the information:
"Cell 1A" Monday, Tuesday, Wednesday

I need to extract this info from this cell so that the same row but in three cells (columns)
"Cell 1A" Monday "Cell 1B" Tuesday "Cell 1C" Wednesday

Is that possible?

 

[Jonmo1]

That sounds like a job for Text to Columns

Highlight column A
Click Data - Text to Columns
Delminated - Next
Comma - Finish

Hope that helps.