Whole document tree
    

Whole document tree

REPLACE

REPLACE

Name

REPLACE -- 

Description

REPLACE returns @old with @new replacing @num characters from @start.

This function is Excel compatible.

Examples

REPLACE("testing",2,3,"*****") equals "t*****ing".

See also

MID, SEARCH, SUBSTITUTE, TRIM.