0
   

Formatted Text (space delimited)

 
 
Reply Mon 15 Aug, 2016 06:56 pm
Hello,

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,
Abdul
  • Topic Stats
  • Top Replies
  • Link to this Topic
Type: Question • Score: 0 • Views: 1,136 • Replies: 1

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

Related Topics

 
  1. Forums
  2. » Formatted Text (space delimited)
Copyright © 2024 MadLab, LLC :: Terms of Service :: Privacy Policy :: Page generated in 0.03 seconds on 04/20/2024 at 07:43:29