REPLACE

REPLACE —

REPLACE(old,start,num,new)

REPLACE returns old with new replacing num characters from start.

This function is Excel compatible.

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

MID, SEARCH, SUBSTITUTE, TRIM.