. : http://uneex.mithril.cs.msu.su/static/GnumericDoc_ru/r8381.html
: Mon Sep 26 12:35:55 2011
: Mon Oct 1 22:55:36 2012
: IBM-866
SUBSTITUTE
úº ̺º Gnumeric
PrevNext

SUBSTITUTE

Name

SUBSTITUTE -- 

Synopsis

SUBSTITUTE(text, old, new [,num])

Description

SUBSTITUTE Ͷúغú @old ɺ @new @text. 広Ͷúضöɶ̶ ʺ̶Ͷöɺ޶úѺк @num-Ƕͺ ʶ кӶúѺ նǺ¶öɶ̺ @old @text, úжȶ ɶ 溧ɶ, Ѷ Ͷöɺ޶úѺк ¶Ƕ նǺ¶öɶ̶.

Ѻ Ժɺ̺ жǶͶúкѶ̶ͺ Excel.

Examples

SUBSTITUTE("testing testing","test","wait",2) equals "testing waiting".

See also

REPLACE, TRIM.

PrevHomeNext
STEYXUpSUBTOTAL