An old joke holds that anyone with two mobile phones is either dealing drugs or having an affair – but in fact, there are plenty of legitimate reasons why you’d want to maintain two separate numbers.

If your Excel cell or row contains two or more values, you can split that data across multiple cells. For Excel to divide the values, however, the cell must contain a delimiter, a character that ...