Formatted Text (space delimited)

Reply 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.
Best Regards,
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 965 • Replies: 1

Reply Mon 15 Aug, 2016 07:03 pm
Have you tried saving it as a .csv file?
0 Replies

Related Topics

  1. Forums
  2. » Formatted Text (space delimited)
Copyright © 2022 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 01/22/2022 at 12:47:55