writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <div id="6SpaceContent" class="zcontent" align="left">+ − '''REPLACEB'''(Old _Text, Start_Num, Num_Char, New_Text)+ + + + − where,+ − '''Old_Text''' - is the text inwhich to replace some characters.+ − + + − '''Num_Char'''- represents the number of characters in Old_Text,to replace with New_Text.+ + + + − '''New_Text''' - the text that replace characters in Old_Text.+ − </div>+ − ---- − − REPLACEB replaces part of a text string, based on the number of bytes you specify, with a different text string. REPLACEB is intended for use with languages that use the double-byte character set (DBCS).+ + + + + − </div>+ − ----+ − <div id="7SpaceContent" class="zcontent" align="left">+ + − If Start_Num < 1, REPLACEB returns #ERROR.+ + + + − If Num_Chars < 1, REPLACEB returns #ERROR.+ + + + − </div>+ − + − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">+ − + − REPLACEB+ − − </div></div> − ---- − <div id="8SpaceContent" class="zcontent" align="left"> − − Lets see an example in (Column1, Row2) − − <nowiki>=REPLACEB(R1C1, 2, 1, "$")</nowiki> − − REPLACEB returns J$HN SMITH. − − Lets see an another example in (Column1,Row3) − <nowiki>=REPLACEB(R1C1, -1, 2, "#")</nowiki>+ + + − REPLACEB returns #ERROR(Start_Num =-1).+ − </div>+ − ----+ − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>+ − ---- − <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div> − ---- − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ---- − <div id="2SpaceContent" class="zcontent" align="left"> − {| id="TABLE3" class="SpreadSheet blue"+ − |+ Default Calci − |- class="even" − | class=" " | − | Column1 − | Column2 − | Column3 − | Column4 − |- class="odd" − | class=" " | Row1 − | JOHN SMITH − | class=" " | − | − | − |- class="even" − | class=" " | Row2 − | class="sshl_f" | J$HN SMITH − | − | − | − |- class="odd" − | Row3 − | class="sshl_f" | #ERROR − | − | − | − |- class="even" − | Row4 − | class=" SelectTD1 ChangeBGColor SelectTD1" | − <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div> − | − | − | − |- class="odd" − | class=" " | Row5 − | class=" " | − | − | − | − |- class="even" − | Row6 − | − | − | − | − |} − − {| id="TABLE3_menu" − | align="right" | TABLE3 − | <span align="left">[[Image:calci1.gif]]</span> − | − | − [[Image:bold.gif]] − | − [[Image:italic.gif]] − | − [[Image:normal.gif]] − | − [[Image:underline.gif]] − | − [[Image:border.gif]] − | − [[Image:numbers.gif]] − | − [[Image:sort.gif]] − | − [[Image:formatcells.gif]] − | − [[Image:graphs.gif]] − | $ − |} − </div>+ − ----
Manuals/calci/REPLACEB (view source)
Revision as of 23:29, 28 December 2013
, 23:29, 28 December 2013no edit summary
=REPLACEB(Old_Text, Start_Num, Num_Char, New_Text)=
*where, <math>Old_Text</math> is the original or old text
*<math>Start_Num</math> represents the character position in old text
*<math>Num_Char</math> represents the number of characters to be replaced in old text
*<math>New_Text</math> is the new text with which specified number of characters in old text are replaced
REPLACEB() replaces a part of old text string with a new text string, based on the number of bytes specified.
== Description ==
'''Start_Num''' - represents the position of the character in Old_Text, to replace with New_Text.
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 <math>Start_Num</math> < 1, Calci displays #N/A message.
*If <math>Num_Char</math> < 1, Calci displays #N/A message.
== Examples ==
<div id="6SpaceContent" class="zcontent" align="left">
<div id="1SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
| class="ssh1_f" |ColumnA
| class=" " |ColumnB
| class=" " |ColumnC
|- class="odd"
| class="ssh1_f" |123456
| class=" " |
| class=" " |
|- class="even"
| class="ssh1_f" |*****
| class=" " |
| class=" " |
|- class="odd"
| class="ssh1_f" |STAR
| class=" " |
| class=" " |
|- class="odd"
----
| class="ssh1_f" |
| class=" " |
| class=" " |
|}
=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.
== See Also ==
*[[Manuals/calci/REPLACE | REPLACE]]
*[[Manuals/calci/SUBSTITUTE | SUBSTITUTE]]
*[[Manuals/calci/REPT | REPT]]
==References==
*[http://en.wikipedia.org/wiki/Autocorrection Find and Replace]