Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
Old 03-01-2013, 01:06 AM
ArviL ArviL is offline SEMICOLONseparated Windows 7 64bit SEMICOLONseparated Office 2007
Novice
 
Join Date: Feb 2013
Posts: 11
ArviL is on a distinguished road
Default

A. Set Window's regional settings to some, where semicolon is a list separator (German, Estonian, etc.). (Maybe it will work also, when you set the list separator for your current regional settings to semicolon.) Open your workbook, be sure that the worksheet you want to convert is only one in workbook or at least the first one. Save AS CSV (Comma Delimited).

B. This works when you don't have any commas in your current entries. Open your workbook, be sure that the worksheet you want to convert is only one in workbook or at least the first one. Save AS CSV (Comma Delimited) and close the csv-file. Open the csv-file with notepad, and replace all commas with semicolons. Save.
Reply With Quote
 



Other Forums: Access Forums

All times are GMT -7. The time now is 12:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft