Splitting values in a CSV file into individual cells

is there a way to split up all the values in one cell in a csv file into individual cells inside of an excel spreadsheet? for example, i open the csv with excel, and in one cell there is open time, close time, open price, close price, etc. is there a function/program/formula that splits all these values into individual cells so i have a cell for open time, close time, etc? or do i have to do it all maually?

Yes..

Data ... Text to Column ... Delimited ....Next......then select your delimiters and then click next or finish.

You have to highlight the column in the beginning.
Your delimiter maybe a comma or space or something.

awesome, thanks bro. that made my job a whole lot easier. lol.