From: Vinz A on
Hi Peter Boettcher

Can you please explain what are the notations inside the sprintf statement
sprintf('%c', 'A' + i - 1)
Even I have the same problem.
It seems to work for one row how do i update for rest of the values.
If I understand then I can try it out.


Cheers
vinz
From: TideMan on
On Jun 30, 9:10 am, "Vinz A" <vin...(a)gmail.com> wrote:
> Hi Peter Boettcher
>
> Can you please explain what are the notations inside the sprintf statement
>  sprintf('%c', 'A' + i - 1)
> Even I have the same problem.
> It seems to work for one row how do i update for rest of the values.
> If I understand then I can try it out.
>
> Cheers
> vinz

The best way to learn/understand is to try it out:
sprintf('%c','A'+1)
sprintf('%c','A'+25)
Can't you see what is happening?


From: us on
TideMan <mulgor(a)gmail.com> wrote in message <f9f64604-0b0b-41b8-9ea4-0d5789cbfdec(a)i31g2000yqm.googlegroups.com>...
> On Jun 30, 9:10 am, "Vinz A" <vin...(a)gmail.com> wrote:
> > Hi Peter Boettcher
> >
> > Can you please explain what are the notations inside the sprintf statement
> >  sprintf('%c', 'A' + i - 1)
> > Even I have the same problem.
> > It seems to work for one row how do i update for rest of the values.
> > If I understand then I can try it out.
> >
> > Cheers
> > vinz
>
> The best way to learn/understand is to try it out:
> sprintf('%c','A'+1)
> sprintf('%c','A'+25)
> Can't you see what is happening?
>

ahhh... NOW i can see what's happening(!)...
thank you so much, tm...

us