Hi Tony,
Why do you need a function, the "Text to columns" method is not a good option?
You can do it with VB, by splitting the content after "," then collect in the sheet all items separately... How the result must be, in a row, or in columns?
Maybe you can create a sample workbook with "before" and "after" data...