deepcalc
DocsREPLACE

REPLACE

View as markdown/docs/functions/replace.md Ask Claude about this pageOpens Claude with this page's address

Replaces characters by position.

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

Examples

=REPLACE("text", 3, 4, "text")
Result tetext

Syntax

REPLACE(old_text, start_num, num_chars, new_text)
old_text
text required
start_num
number required
num_chars
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.