Mon 15 Aug, 2016 06:56 pm
I am PhD student in Beijing, China. My major is about Biological Sciences.
I have the data in excel format, I want to convert it into formatted text(space delimited), I tried in excel the save as option but it did not work.
As a matter of fact I know some text editors such as notepad++ and others, but then again notepad++ and other text editors did not convert properly. It gave very strange format. I confirmed it while opening txt file in excel converted by text editor. All my efforts went in vain. May be I am missing key point in conversion.
Could you tell me other software or way to convert excel into formatted text (space delimited)?
I even tried to replace comma by space in text editor, but it did not work.
please keep in mind title header is important, I can not strip out them. Just in case If I strip them out, I might lose important information.
Have you tried saving it as a .csv file?