Difference between revisions of "Manuals/calci/REPLACE"
Jump to navigation
Jump to search
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | =REPLACE( | + | <div style="font-size:30px">'''REPLACE (Old_Text,Start_Num,Num_Chars,New_Text) '''</div><br/> |
| − | *where <math> | + | *where <math>Old-Text</math> is the original or old text |
| − | *<math> | + | *<math>Start-Num</math> is the character position in old text |
| − | *<math> | + | *<math>Num-Chars</math> is the number of characters to be replaced in old text |
| − | *<math> | + | *<math>New-Text</math> is the new text that replaces the characters in old text |
| − | + | **REPLACE(), replaces characters within text. | |
| − | REPLACE() replaces | ||
== Description == | == Description == | ||
| − | REPLACE( | + | REPLACE (Old_Text,Start_Num,Num_Chars,New_Text) |
For Example, | For Example, | ||
| Line 18: | Line 17: | ||
In above example, original text is replaced with new text from 4th character to next 4 characters. | In above example, original text is replaced with new text from 4th character to next 4 characters. | ||
| − | *<math> | + | *<math>Old-Text</math> and <math>New-Text</math> should be enclosed in quotes. |
| − | *<math> | + | *<math>Start-Num</math> and <math>Num-Chars</math> should be positive numbers. |
| − | *If <math> | + | *If <math>Start-Num</math> and <math>Num-Chars</math> are non-integers, they are truncated. |
| − | *If <math> | + | *If <math>Start-Num</math> > 'length of <math>Old-Text</math>' , 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. | *If any arguments are invalid, Calci displays an #ERROR message. | ||
Latest revision as of 15:31, 13 August 2018
REPLACE (Old_Text,Start_Num,Num_Chars,New_Text)
- where is the original or old text
- is the character position in old text
- is the number of characters to be replaced in old text
- is the new text that replaces the characters in old text
- REPLACE(), replaces characters within text.
is the original or old text
is the character position in old text
is the number of characters to be replaced in old text
is the new text that replaces the characters in old 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.
- and should be enclosed in quotes.
- and should be positive numbers.
- If and are non-integers, they are truncated.
- If > 'length of ' , 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
See Also
References