Replace(expression, find, replace[, start[, count[, compare]]])
| Parameter | Description | | expression | Required. String expression containing substring to replace. | | find | Required. Substring being searched for. | | replace | Required. Replacement substring. | | start | Optional. Default 1. Position within expression where substring search is to begin. | | count | Optional. Default -1 (All). Number of substring substitutions to perform. | | compare | Optional. Default vbBinaryCompare (0). Numeric value indicating the kind of comparison to use when evaluating substrings. |
|
Dim St as String
St = "Chennaiiq"
| Statement | Result | Remark | | Replace(St, "n", "m") | Chemmaiiq | | | | Replace(St, "N", "m") | Chennaiiq | | | | Replace(St, "n", "M") | CheMMaiiq | | | | Replace(St, "n", "m", 5) | maiiq | | | | Replace(St, "n", "m", 4, 1) | mnaiiq | | | | Replace("", "n", "m") | | Empty String | | | Replace(null, "n", "m") | Error | Invalid use of null | | | Replace(St, "", "m") | Chennaiiq | (Copy of Expression) | | | Replace(St, "n", "") | Cheaiiq | | | | Replace(St, "n", "m", 20) | | Empty String | | | Replace(St, "n", "m", 1, 0) | Chennaiiq | |
|