REPLACE

Borrote naanni fikiimi biso babbaxitino borro naanni fikiimira riqiwanno. Kuni assiishshi lamenta fikiimootanna kiirra (umi loosaanchinni borrote soorrantinota)riqiwate kaa'la dandaanno. Asiishshu gumi duucha wote borrote gede leellanno. Borrotenni riqiwantino kiironni shallagate looso loosa hasirittoro, Hornyo assiishsha horoonsidhe badhera kiirote soorra hasiissanno.

Any text containing numbers must be enclosed in quotation marks kiirote gede karsannaumi loosaanchinni borrote widira soorra hasira hoogittoro ayee borro amaddino kiiro bicammete malaati giddo cufama noose.

Ganallo

Riqiwi("Borro"; Ofolla; Hojja; "HaarooBorro")

Text refers to text of which a part will be replaced.

Position refers to the position within the text where the replacement will begin.

Length is the number of characters in Text to be replaced.

NewText refers to the text which replaces Text.

Lawishsha

=REPLACE("1234567";1;1;"444") returns "444234567". One character at position 1 is replaced by the complete NewText.

REPLACE wiki page.

Text Functions