csv delimeter

C

csv delimeter

How do I save an excel as a csv while specifying something other than comma
as a delimeter?
 
J

Jacob Skaria

You can have a VBA solution to save with the delimiter you like. Another way
is to save as tab delimited (.txt) or .csv and then open the file in notepad
or a text editor and replace tab/comma with the delimiter of your wish.

If this post helps click Yes
 
D

Dave Peterson

You could change your list separator to the character that you want in windows
control panel (regional settings applet).

Remember to change it back. You may not like what happens to other stuff--like
formulas in excel.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save Excel file to CSV with quotation mark data delimeter? 2
Converting excel 2007 to tab delimeter text file 1
Data, Text to Columns, has commas in the text, plus as a delimeter 2
convert to csv using macro gives wrong seperator 2
Regarding .CSV files 1
How do I save to csv and get text delimeters? 1
export data to csv file from calendar 1
How do import data using | as a delimeter? 3

Top