writer
6,694
edits
Changes
no edit summary
=REPLACEB(Old_Text, Start_Num, Num_Char, New_Text)=
=REPLACEB(Old_Text, Start_Num, Num_Char, New_Text)=
<div style="font-size:30px">'''REPLACEB (Old_Text,Start_Num,Num_Chars,New_Text) '''</div><br/>
*where, '''Old_Text''' is the original or old text
*where, '''Old_Text''' is the original or old text
*'''Start_Num''' represents the character position in old text
*'''Start_Num''' represents the character position in old text
*'''Num_Char''' represents the number of characters to be replaced in old text
*'''Num_Chars''' represents the number of characters to be replaced in old text
*'''New_Text''' is the new text with which specified number of characters in old text are replaced
*'''New_Text''' is the new text with which specified number of characters in old text are replaced
**REPLACEB(), replaces characters within text.REPLACEB is intended for use with languages that use the double-byte character set (DBCS).
REPLACEB() replaces a part of old text string with a new text string, based on the number of bytes specified.
== Description ==
== Description ==
*REPLACEB is intended for languages that use double-byte character set (DBCS).
*REPLACEB is intended for languages that use double-byte character set (DBCS).
*If '''Start_Num''' < 1, Calci displays #N/A message.
*If '''Start_Num''' < 1, Calci displays #N/A message.
*If '''Num_Char''' < 1, Calci displays #N/A message.
*If '''Num_Chars''' < 1, Calci displays #N/A message.
== Examples ==
== Examples ==