When splitting a cell that contains text the text is moved to the?

When splitting a cell that contains text, the text is typically moved to the first newly created cell, while the remaining cells will be empty or contain default values, depending on the software used. This process effectively divides the original cell's content, allowing for better organization of data. If the operation involves multiple cells, the text may be distributed differently based on the specific splitting method applied.