Using the Excel Text to Column feature, you can choose how to split the column up, fix the width, or split at each comma, period, or other characters.

Traditional Ways to Adjust Column Widths (Manually) In this example, Excel's default column width isn't wide enough to show all the text in column A.

How to Keep Leading Zeros in CSV. Microsoft Excel can use data produced by other computer applications that is saved in the text-based Comma-Separated Value file format. Excel knows how to convert ...