Windows Forum

Ask something
Discussion Locked

Save as a file separated by comma

0 helpful
3 replies

by ogruizr 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all :

I have a Windows 2000 Prof. Personal Computer with Microsoft Office 97 installed. I created a new file excel. Then I saved file as a text file separated by comma but it's saved separated by semicolon. I need it separated by comma. I don't need it separated by semicolon. How can I fix this problem?

3 replies

by brad_wyder

Export the data to a text file and it will give you the option to select what you want to delimit by. Make sure you choose export to text file.

by oz_media

DON'T SAVE AS TEXT!!

When you choose SAVE from the FILE menu. In the SAVE AS FILE TYPE box, use the drop down meny and select CSV Comma delimited.
The Semi colon will be from saving as a TEXT DELIMITED file type instead of CSV.

OM

This discussion is closed to new replies.