REPLACEB

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

แžšแžผแž”โ€‹แžแŸ†แžŽแžถแž„โ€‹แž–แŸแžแŸŒแž˜แžถแž“โ€‹แž‡แŸ†แž“แžฝแž™

This function is available since LibreOffice 6.0.


แžœแžถแž€แŸ’แž™โ€‹แžŸแž˜แŸ’แž–แž“แŸ’แž’โ€‹โ€‹

REPLACEB( Text ; Position ; Length ; NewText )

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

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

Length: the number of bytes to be replaced.

NewText: the text to be inserted.

แžงแž‘แžถแž แžšแžŽแŸ

=REPLACEB("แ„ฉแ„”แ„•แ„œแ„แ„žแ„ แ„ขแ„ฃแ„ซแ„ฌแ„ญแ„ฎแ„ฏแ„ฒแ„ถ";4;1;"ab") returns "แ„ฉ abแ„•แ„œแ„แ„žแ„ แ„ขแ„ฃแ„ซแ„ฌแ„ญแ„ฎแ„ฏแ„ฒแ„ถ" .

แž”แŸ’แžšแž’แžถแž“แž”แž‘โ€‹แž‘แžถแž€แŸ‹แž‘แž„

แžšแžผแž”โ€‹แžแŸ†แžŽแžถแž„โ€‹แž–แŸแžแŸŒแž˜แžถแž“โ€‹แž‡แŸ†แž“แžฝแž™

REPLACEB wiki page.


FINDB

SEARCHB

LENB

LEFTB

RIGHTB

MIDB

REPLACEB

Please support us!

Please support us!