To split the cells, start by selecting the merged cells on the sheet. Next, navigate to the Alignment group in the ribbon of the Home tab. Click the down arrow next to the Merge and Center button and ...

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.