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