This feels like a really stupid problem, but I have yet been able to find a solution. I'm working with a textfile that contains 6 columns of information and basically I need to import the text file into excel, modify column B which is a column of dollar amounts and then save the file as a text again in order for it to be used with Oracle financial it must maintain the same format.
However when I save this file to text it does not maintain the formatting and the columns are all mixed together or the spacing has changed and I cannot go through line by line (there are a few thousand rows) to correct this.
I believe this is happening because some of the columns contain data of different lengths (description or verification for example range from 20 to 50 characters) however I have been unsuccessful in my attempts to pad these all up to the same width using spaces.
Can anyone possibly provide a better solution with this little amount of information?