Manuals/calci/REPLACE
Jump to navigation
Jump to search
REPLACE(otxt,snum,noc,ntext)
where otxt is text that want to replace some characters and
snum is the position of the character in otxt and
noc is the number of characters in otxt and
ntxt is the text that will replace characters in otxt.
REPLACE(otxt,snum,noc,ntext)
where otxt is text that want to replace some characters and
snum is the position of the character in otxt and
noc is the number of characters in otxt and
ntxt is the text that will replace characters in otxt.
REPLACE
Let’s see an example in (Column1 Row 1)
I.e.C1R1 =Inspiration
=REPLACE(C1R1,5,3,”@”) is Insp@tion
Syntax
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Inspiration | Insp@tion | ||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
