Manuals/calci/SUBSTITUTE
Jump to navigation
Jump to search
SUBSTITUTE(txt,od_txt,nw_txt,inst_n)
'
where txt is the text that want to substitute characters and od_txt is the text that want to replace and
nw_txt is the text that want to replace od_txt with and
inst_n is the occurrence of od_txt that want to replace with nw_txt.
It replaces new text for old text in a text string.
SUBSTITUTE
Let’s see an example in (Column1 Row 1)
C1R1 = Cost Price
I.e.=SUBSTITUTE(C1R1,”Cost”,”Selling”) is
Selling Price
Syntax
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Cost Price | Selling Price | ||
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
