Splitting 1 cell into 4 cells VBA
Some general ideas first, without fully understanding your criteria:

Work with arrays, not with ranges

name the variables according to their function, be precise


CellInfo => CellContentLength, LengthOfCellText, ...
mergedCells => CellsToSplit
cellRow => CurrentCell, ...