/P# |
Meaning |
Extra Parameters: /1{Parameter1} … /n{Nth Parameter} |
109 |
Search for and replace the contents of a cell within a spreadsheet |
/1 = sSheet – worksheet to be modified (by name or number) /2 = sSearchFor – text to be modified /3 = sReplaceWith – replacement text /4 = sRange – Specify a range, or omit to use ‘used range’ /5 = bCaseSensitive – “TRUE” or “FALSE” /6 = bLookAtPart – “TRUE” or “FALSE” /7 = bMatchByte – “TRUE” or “FALSE” |
This special process allows you to search for text within cells and replace it with other text.
Special Parameters Described in Detail
/1{sSheet} Name of the sheet to modify. Required.
/2{sSearchFor} A string that will be searched for and replaced. Required.
/3{sReplaceWith} A string that is the replacement text. Required.
/4{sRange} A string to optionally specify the range to do the search and replace on. For example /3“D:D” will do column D only.
/5{bCaseSensitive} “TRUE” to check case sensitivity or “FALSE” to ignore it.
/6{bLookAtPart} “TRUE” to replace the search string wherever it is found or “FALSE” to replace it only when it comprises the entire cell contents.
/7{bMatchByte} “TRUE” to match double byte to single byte characters or “FALSE” to ignore it.
Examples:
EXAMPLE 1 Search for "Marine Science" and replace with "Oceanography"