REPLACE

Microsoft Office Spreadsheet Functions

Show All

REPLACE

See Also

REPLACE replaces part of a text string, based on the number of characters you specify, with a different text string.

Syntax

REPLACE(old_text,start_num,num_chars,new_text)

Old_text   is text in which you want to replace some characters.

Start_num   is the position of the character in old_text that you want to replace with new_text.

Num_chars   is the number of characters in old_text that you want REPLACE to replace with new_text.

New_text   is the text that will replace characters in old_text.

Example

The example may be easier to understand if you copy it to a blank spreadsheet.

How?

Data
abcdefghijk
2009
123456
Formula Description (Result)
=REPLACE(A2,6,5,"*") Replaces five characters, starting with the sixth character (abcde*k)
=REPLACE(A3,3,2,"10") Replaces the last two digits of 2009 with 10 (2010)
=REPLACE(A4,1,3,"@") Replaces the first three characters with @ (@456)