REPLACEB

Returns text where an old text is replaced with a new text, using byte positions.

tip

Ta funkcija je na voljo od LibreOfficeDev 6.0


Skladnja

REPLACEB( Text ; Position ; Length ; NewText )

Text: A text expression or reference to a cell containing a text expression in which the characters are to be replaced.

Position: the character position from which text is to be replaced.

Length: the number of characters to be replaced.

NewText: the text to be inserted.

Primeri

=REPLACEB("ᄩᄔᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ";4;1;"ab") returns "ᄩ abᄕᄜᄝᄞᄠᄢᄣᄫᄬᄭᄮᄯᄲᄶ" .

FINDB

SEARCHB

[text/scalc/01/04060110.xhp#lenbvar not found].

[text/scalc/01/04060110.xhp#leftbvar not found].

[text/scalc/01/04060110.xhp#rightbvar not found].

[text/scalc/01/04060110.xhp#midbvar not found].