Re: [office-comment] [formula] Comments on SUBSTITUTE()

[Brad Hards <bradh@frogmouth.net>]

On Tuesday 16 January 2007 04:19, Eike Rathke wrote:
> Hi Brad,
>
> On Saturday, 2007-01-13 10:35:48 +1100, Brad Hards wrote:
> > > > =SUBSTITUTE("121212";"2";"ab";2)
> > > > produces 121ab12 with oocalc and gnumeric, but 1ab1ab12 with kspread.
> > >
> > > All except Kspread produce "121ab12", this seems to be an error of
> > > KSpread.
> >
> > I am concerned about being able to import from excel.
>
> Please note that the 'all' in "all except KSpread" includes Excel.
> Kspread is the only application that does not produce "121ab12".
My sincere apologies - I was misled by my Excel book (Paul McFedries "Formulas 
and Functions with Microsoft Excel 2003", pg 152) which says the fourth 
argument is the "number of replacements to make".

I tried it with Excel 2003 today, and it certainly does work the way the spec 
describes. Sorry about the noise.

Brad