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.