Exporting from excel into a specific format
Hi all,
I'm new here, so sorry if I've posted in the wrong place, and I know nothing about computers so sorry in advance if this is a stupid question. I'm trying to export data from excel in a specific format. I've attached an example of what the excel file looks like. The format I want it to be in is in the first text file (samp_inp_2b.txt). When I export from excel as unicode or tab delimited it results in the second text file (sample2db.txt). As far as I can tell the two text files are the same but the line breaks are different, in the first one the linebreaks are there but don't display for some reason (at least in notepad). Does anyone know how to export data from excel to get the first text file format? If anyone knows how to directly convert between the 2nd and 1st text files that would also do the job.
Thanks in advance!
|