<div>
the how to geek article is for Windows Excel. &nbsp;I found that article before I ever posted the question. &nbsp;Additionally, the save as opiton on my Excel doesn't have the &quot;Other Formats&quot; option. &nbsp;Although, it is a great article for a Windows user.<br />
<br />
I received a .xls worksheet that is tab delimited. &nbsp;Since it is in a .xls format TextWrangler isn't allowing me to the see the data. &nbsp;So, you mentioning the TextWrangler option gave me the idea to export it as .csv then use TW to change them to semicolons.<br />
<br />
Since neither of you had the complete answer I have decided to split the points.<br />
<br />
Thanks,<br />
<br />
Randal
</div>


the how to geek article is for Windows Excel.  I found that article before I ever posted the question.  Additionally, the save as opiton on my Excel doesn't have the "Other Formats" option.  Although, it is a great article for a Windows user.

I received a .xls worksheet that is tab delimited.  Since it is in a .xls format TextWrangler isn't allowing me to the see the data.  So, you mentioning the TextWrangler option gave me the idea to export it as .csv then use TW to change them to semicolons.

Since neither of you had the complete answer I have decided to split the points.

Thanks,

Randal

<div>
Thanks for both of your answers.
</div>


<div>
<div class="content wysiwyg-content">
I have a worksheet that I have been given that uses tabs for delimiters. &nbsp;My update script needs it to have a delimiter as a semi colon instead. &nbsp;Please tell me how to export to a .txt file with a semicolon as a delimiter.<br />
<br />
Thanks,<br />
<br />
Randal
</div>
</div>


I have a worksheet that I have been given that uses tabs for delimiters.  My update script needs it to have a delimiter as a semi colon instead.  Please tell me how to export to a .txt file with a semicolon as a delimiter.

Thanks,

Randal

Excel Mac 2008 Worksheet Export Text File With Semicolon Delimiter

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Mac OS X is the desktop operating system from Apple Inc., found on Macintosh computers. OS X consists of a Mach/BSD-based kernel, operating system interfaces primarily based on FreeBSD and additional frameworks (written in C, C++ and Objective-C providing user interface and application-level services.

Mac OS X

Swift is a compiled programming language created for iOS, OS X, watchOS, tvOS and Linux development by Apple Inc. Swift is designed to work with Apple's Cocoa and Cocoa Touch frameworks and the large body of existing Objective-C code written for Apple products. Swift is intended to be more resilient to erroneous code ("safer") than Objective-C and also more concise. It is built with the LLVM compiler framework included in Xcode 6 and later and uses the Objective-C runtime, which allows C, Objective-C, C++ and Swift code to run within a single program. A second free implementation of Swift targets Microsoft's Common Language Infrastructure (a.k.a. .NET) and the Java/Android platform.