Difference between revisions of "Manuals/calci/SUBSTITUTE"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#484848"><font face="Arial, sans-serif"><font size="2">'''SUBSTITUTE'''</font></font></font><font color=...") |
(No difference)
|
Revision as of 21:45, 24 October 2013
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 |