I'm trying to copy something into Excel while keeping the formatting exactly as it appears in the file.
The file is a normal text file (actually its this one http://db.gamefaqs.com/computer/doswin/file/oblivion_stats_level.txt - Do a search for [RA000] and [RA001] for the two tables) and I'm trying to copy the 1H and 2H blade weps into one sheet to combine the two lists.
When I do text to columns the "level" column changes values, for example 01-Jun when it should be 1-6. Any way to stop this stupid auto formatting? I've tried to format cells to Text before doing text to columns but it changes regardless afterwards!
Can anyone help? Would be good to know for future reference too.
The file is a normal text file (actually its this one http://db.gamefaqs.com/computer/doswin/file/oblivion_stats_level.txt - Do a search for [RA000] and [RA001] for the two tables) and I'm trying to copy the 1H and 2H blade weps into one sheet to combine the two lists.
When I do text to columns the "level" column changes values, for example 01-Jun when it should be 1-6. Any way to stop this stupid auto formatting? I've tried to format cells to Text before doing text to columns but it changes regardless afterwards!
Can anyone help? Would be good to know for future reference too.