The statement "the cell reference for the merged cell is the upper-right cell reference" is incorrect.
Ussually the reference for a set of merged cells in Microsoft Excel is the top left cell. And any content that was present in this cell before merging will be distributed into the new large cell, also after splitting the cells, all of the content is shifted into the top left cell.