Formula to split text based on a specific delimiter

Hi All,

I'm using the formula in the attached spreadsheet to split out values in a single into separate columns based on "," as a delimiter.

The formula works fine up to a point, but after a certain number of valves it produces an error across every column.

I'm thinking that one of the functions used might have an inbuilt character limit, where by if the single cell it's reading contains too much data, the formula fails to function.

The attached spreadsheet show the 2 scenarios, with the top section working as intended, but the bottom in error due to added values in cell B5.


I would very much appreciate if you guys could shed some light on this, or maybe provide an alternate means to accomplish the same result.


Thank you in advance,

Robert.