Description: Returns a string where all instances of the
Search string are replaced with the Replace
string in the Text string. Optionally multiple search and
replace pairs can be given.
Text : string to search Search : string to search Replace :
string to replace the instances of the Search string.
=ReplaceAll("As quick as
1,2,3",1,"one",2,"two",3,"three") Result: "As quick as
one,two,three"
Copyright (C) 1995-2010 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.
sitemap