Split data with vba code after every comma.

Is it possible to write a code, that after every comma the text is splitted to different collumns, in the same row.

Split data doesn't do the trick

In the first sheet, two examples. In the second sheet the result i need. Instead of one column, it needs to be multiple columns (after every single comma). And every example in one row.

See attachment

Duplicate post

http://www.excelforum.com/excel-prog...ery-comma.html