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

Regardless of whether you are using Excel or another spreadsheet program, inserting two or more lines of text into one cell is straightforward.

For Excel to divide the values, however, the cell must contain a delimiter, a character that specifies where the first number ends and the second one begins.