Manuals/calci/REPLACEB
REPLACEB(Old _Text, Start_Num, Num_Char, New_Text)
where,
Old_Text - is the text inwhich to replace some characters.
Start_Num - represents the position of the character in Old_Text, to replace with New_Text.
Num_Char- represents the number of characters in Old_Text,to replace with New_Text.
New_Text - the text that replace characters in Old_Text.
REPLACEB replaces part of a text string, based on the number of bytes you specify, with a different text string. REPLACEB is intended for use with languages that use the double-byte character set (DBCS).
If Start_Num < 1, REPLACEB returns #ERROR.
If Num_Chars < 1, REPLACEB returns #ERROR.
REPLACEB
Lets see an example in (Column1, Row2)
=REPLACEB(R1C1, 2, 1, "$")
REPLACEB returns J$HN SMITH.
Lets see an another example in (Column1,Row3)
=REPLACEB(R1C1, -1, 2, "#")
REPLACEB returns #ERROR(Start_Num =-1).
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | JOHN SMITH | |||
| Row2 | J$HN SMITH | |||
| Row3 | #ERROR | |||
| Row4 | ||||
| Row5 | ||||
| Row6 |
| TABLE3 | File:Calci1.gif | $ |
