Manuals/calci/REPLACE

REPLACE(otext, snum, noc, ntext)

REPLACE (Old_Text,Start_Num,Num_Chars,New_Text)

• where $Old-Text$ is the original or old text
• $Start-Num$ is the character position in old text
• $Num_{C}hars$ is the number of characters to be replaced in old text
• $New_{T}ext$ is the new text that replaces the characters in old text
  • REPLACE(), replaces characters within text.

Description

REPLACE (Old_Text,Start_Num,Num_Chars,New_Text)

For Example,

REPLACE("WELCOME",4,4,"-COME") returns WEL-COME

In above example, original text is replaced with new text from 4th character to next 4 characters.

• $Old-Text$ and $New-Text$ should be enclosed in quotes.
• $Start-Num$ and $Num-Chars$ should be positive numbers.
• If $Start-Num$ and $Num-Chars$ are non-integers, they are truncated.
• If $Start-Num$ > 'length of $Old-Text$' , Calci assumes it to be '0'(zero) and new text is appended before old text.
• If any arguments are invalid, Calci displays an #ERROR message.

Examples

ColumnA	ColumnB	ColumnC
123456
replace
ABCDEF
Mango

=REPLACE(A1,2,1,"two") : Replaces second character from old text with "two". Returns 1two3456 as output.
=REPLACE(A2,3,5,"PLACE") :Replaces 5 characters from old text starting from 3rd position with upper case "PLACE". Returns rePLACE as output.
=REPLACE(A3,6,1,"fghijk") : Replaces 6th character from old text with lower case "fghijk". Returns ABCDEfghijk as output.
=REPLACE(A4,8,1,"Apple ") : Appends "Apple " before old text as snum is greater than length of old text. Returns Apple Mango as output.

Related Videos

REPLACE

See Also

• REPLACEB
• SUBSTITUTE
• REPT

References

• Find and Replace

• List of Main Z Functions

• Z3 home