500 characters to 500 cells

I have a txt file that is exactly 500 characters wide and can have several thousand ‘rows’ of data that are also exactly 500 characters wide. Frequently I am required to scroll through such files and find issues with the data. That is very time consuming and modifying a file like this is difficult, tedious, and frequently leads to more data issues. 

Horrifying I know. 

What I would like is a reasonably easy way to convert each individual character to a cell so that the file is easier to understand and edit. 

I know there is a way to convert text to columns with custom column widths, but clicking through each file ~ 500 times is time consuming and is also prone to human error. 

By: Patrick Murphy

Leave a Reply

Your email address will not be published. Required fields are marked *