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