Convert csv type back to rows or columns

[DevintheDude]

I have cells with lots of data that seperated by commas and i want to get that data between the commas and make them rows

 

[Scott Huish]

Your subject says rows or columns, but you don't want to put each piece of data in its own column, you want to put each piece in a row, is this correct?

 

[DevintheDude]

Yes that is correct I was thinking that it really did not matter because i can transpose it to what i need

what ever is easier to do i just want to get the data in multiple cells instead of just one cell

 

[Scott Huish]

Then just select your column of data.
Click on Data, then Text to Columns
Select Delimited
Click Next
Under Delimeters, check Comma only
Click Finish.

 

[DevintheDude]

That worked just perfect