From ZCubes Wiki
Jump to navigation Jump to search
REPLACEB (Old_Text,Start_Num,Num_Chars,New_Text)

  • where, Old_Text is the original or old text
  • Start_Num represents the character position 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
    • REPLACEB(), replaces characters within text.REPLACEB is intended for use with languages that use the double-byte character set (DBCS).


For Example, REPLACEB("JOHN",2,1,"$") returns J$HN

  • This function counts and replaces specified number of byte characters with a new text string.
  • REPLACEB is intended for languages that use double-byte character set (DBCS).
  • If Start_Num < 1, Calci displays #N/A message.
  • If Num_Chars < 1, Calci displays #N/A message.


ColumnA ColumnB ColumnC
=REPLACEB(A1,1,2,"*") : Replaces first two characters from old text with "*". Returns *3456 as output.
=REPLACEB(A2,2,1,"@") :Replaces first byte (2 characters) from old text with upper case "@". Returns @**** as output.
=REPLACEB(A3,2,1,"aa") : Replaces 2nd character from old text with "aa". Returns SaaAR as output.

Related Videos


See Also