writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 52:
Line 52: − − <font color ="Red">Need to give examples with characters/language supporting DBCS </font>
→Examples
=REPLACEB(A2,2,1,"@") :Replaces first byte (2 characters) from old text with upper case "@". Returns '''@****''' 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.
=REPLACEB(A3,2,1,"aa") : Replaces 2nd character from old text with "aa". Returns '''SaaAR''' as output.
==Related Videos==
==Related Videos==