Click on the cell that you want to change into a series of numbers spread out over several columns, or click on the letter above the column that contains multiple phone numbers.

Combine an Excel custom format with data validation and remove the pressure for input perfection from personnel by letting Excel do the work.