Data Scrambling after save when reopening

[hawkfan1]

I am pulling down some data and then delimiting it into different columns. Everything looks fine and I then save the document, however, when I re-open the excel document the data appears scrambled....data is not in the correct column and I am not sure why this is happening. Has anyone else experienced this or have any solutions?

Thanks

 

[DataBlake]

can you provide any codes/formulas within the workbook? perhaps some before and after examples?
any vba components? file type you're saving as? what does "pulling down" mean? how are you delimiting it?

 

[Joe4]

Where is this data coming from?
What format is it in? Is it an Excel file? A text file? Something else?
How are you saving it (as an Excel file or something else)?

 

[hawkfan1]

It is a report that is generated from Discovery. it is just in a normal excel file. It is being saved as a normal excel file, not as one that has macros etc. There are no formulas in it. I am using the text to column feature to separate out the information from one column into multiple columns.

 

[Joe4]

Can you post some examples, a line or two with what the data looks like before, then after, so we can see more clearly what you are talking about?

 

[DataBlake]

it is just in a normal excel file. It is being saved as a normal excel file

This could be a bunch of things such as XLSX or CSV (by the sound of it). If its a CSV then you may need to make sure thats it CSV comma delimited upon saving

I am using the text to column feature to separate out the information from one column into multiple columns.

are you seperating by tab, space, special character, or something else?