REPLACEB

Replaces characters by byte position.

Excel: Not checked yet
Google Sheets: Not checked yet
Returns: Text

Examples

=REPLACEB("text", 3, 4, "text")

Result tetext

Syntax

REPLACEB(old_text, start_num, num_bytes, new_text)

old_text: text required
start_num: number required
num_bytes: number required
new_text: text required

ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.