Distributing the Cell's Contents to Adjacent Columns

Excel file teaching how to perform Distributing the Cell's Contents to Adjacent Columns operation.

Excel Professional Distributing the Cell's Contents to Adjacent Columns

The TEXTTO COLUMNS tool is used. The separator character is defined. Gaps are being cleared. Columns expand automatically. The resulting table looks orderly.

Hope it is useful.