I have a number of cells that contain comma separated lists of numbers in them.
The lists are of varying lengths, and theoretically some of the numbers could be double-digits.

For example:

A1 = 1,1,1,2,1,5,3
B1 = 2,10,4
etc.

I would like to find the average of each cell, as well as the overall average of all cells.

I realise I could use text-to-columns, but the data needs to remain as it is.

Thank you.