How to extract specific data from a cell into another cell Excel

[meghanath1985]

My cell data goes like this : -

ABB.NS,922.30,"10/5/2010",-10.65,922.00,933.00,890.15,281399

I want to sepearte the above data into different cells, the criteria of separation being the "," (comma). The characters doesn't have same number of characters, Say in the next line ABB.NS is replaced by DIVISLAB.NS.

How do I do this in Excel.

[davesexcel]

Location:can...

Check out text to columns.
Select the Range goto data, text to columns,delimited,next,select the delimiters or add another.