Reset the delimiters used with Excel

November 21, 2016

When you save a worksheet from Excel it will automatically use commas for a delimited file  - a comma separated value (.csv) file.   Windows provides a way to reset this default setting.   Go to Start . . .  Control Panel.    Click on the item, Region and Language.    At the bottom right click on 'Additional Settings'.

 

 

On the numbers tab you'll see that you that there is an option to set the List Separator.

 

 Changing this value to another delimiter such as a tilde or pipe will cause your .csv files to be exported differently:

 

 

However be aware that after you've done this when entering formulas in Excel you will now need to replace commas with the new value:

 

 

 

Please reload

Contact Me With Your Litigation Support Questions:

seankevinoshea@hotmail.com

  • Twitter Long Shadow

© 2015 by Sean O'Shea . Proudly created with Wix.com