/
REPLACE
REPLACE
- Juliane Wetzel
- Konsta Danyliuk (Deactivated)
Owned by Juliane Wetzel
Syntax
REPLACE(<string>; <number for start position>; <number of characters to replace>; <string replacement>)
Description
Replaces characters within a text string with a different text string.
Values less than zero for position or length cause an exception for actual data entry.
Examples
| String | Number of starting position | Number of characters to replace | String replacament | REPLACE returns |
|---|---|---|---|---|
| agfa | 1 | 2 | bbbb | abbbba |
| agfa | 1 | 10 | bb | abb |
| agfa | 2 | 1 | b | agba |
, multiple selections available,
Related content
REPLACEALL
REPLACEALL
Read with this
REPLACE
REPLACE
More like this
LEFT
LEFT
Read with this
REPLACE
REPLACE
More like this
REGEXTRACT
REGEXTRACT
Read with this
SUBSTITUTEALL
SUBSTITUTEALL
More like this