Follow these steps to change the contents of the values or formulas of a cell or range of cells:
1. Select the special process “[116] (*.XLS) Change Cell contents.” from the Special Process drop down list. The file format is automatically set as *.XLS.
2. Next select the input and output files. If the input and output files specified are different, a new output workbook will be created.
3. Click the Click here for Change Cell Content Details button.
a. Specify a sheet to modify. You can use the name or number of a sheet.
b. Specify the Range you want to change. For example to specify the column Q you could use “Q:Q”.
c. Specify the new cell contents.
d. Lastly, tell ‘Convert XLS’ what you want to change, the Value of the cell, or the Formula. Be sure to add the equal sign, =, if you are changing it to a formula. Click Done.
4. Optionally click the Add button to add the task to the Conversion Task list. You may add multiple tasks to the Conversion Task list before initiating the conversion process by repeating Steps 1 - 3 as necessary.
5. Click the Convert button to execute the process.
See also Search and Replace Cell Content