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