To split text across cells without using Merge & Center, click Formt Cells. The, on ** Alignment** tab, click**_**.
Data tab > Text to columns
Text control > Merge cells
Vertical > Center across selection
Horizontal > Center across selection