EXAMPLE 1 Search for "Marine Science" and replace with "Oceanography"

To find any occurrences of "Marine Science" and change them to "Oceanography" in Excel spreadsheet "C:\Courses.xls" the following syntax would be used:

ConvertXLS.EXE /S"C:\Courses.XLS" /T"C:\Output\CoursesRevised.XLS" /P109 /1"Sheet1" /2 Marine Science /3 Oceanography /5 TRUE /6 TRUE /7 FALSE

The /S and /T switches specify input and output workbook respectively. Special process 109 is indicated, followed by the arguments: /1 specifies "Sheet1" to be modified; /2 defines the string to be searched for, note that there are no quotation marks necessary here; /3 defines the replacement string; /5 specifies the search will be case sensitive; /6 determines that anywhere the search string is found it will be replaced; and, /7 specifies that there will not be matching of double and single byte characters.