Converting .xls to .csv

[SamDemon]

Hi All!!!!

thanks in advance... the problem is that when i convert my files from xls to csc the contents of the cells do not go into "marks". This is a major problem for us because if the text is not in "marks" then we can not upload them into our system. Any help will be gratefully appreciated.

Rgds

Sam

It's just common sense, shame sense isn't common!

 

[sawedoff]

You may want to try saving as a tab delimited text file, then open the file and replace all the Tab fields with ",".

If you use notepad, the easiest way to get the tab field into the Find box is to copy and paste from your document.

The reason I didn't suggest saving as a CSV then replacing commas is that if you had any commas in you file already, Excel would have already put those fields in ""s. However, if you have no commas in your file anywhere, that would be an easier replacement.

Sawedoff

 

[SamDemon]

thanks for the response... i do however need all the words with " ". Any idea how to do this, i.e.

"abc" "def" "hijkl"

thanks again

Sam

It's just common sense, shame sense isn't common!

 

[sawedoff]

The tab method should work. The only thing you need to do after the replacement is rename the file with .csv instead of .txt

Sawedoff